Automated login to network

M

mpov

I have an Access process that pushes a csv file to a network drive. The
drive has a separate user name and pwd. Does anyone have code that can
automatically log me in? This is a automated process that will run nightly
so manual intervention is not an option.

Thanks in advance.
 
J

Jim Evans

I do this type of thing with a .vbs script or a .bat script. After the
script is created and saved to a particulat folder on c:\, I create a
Scheduled Task to run the script. The Scheduled Task requires credentials.

I believe the user credentials you use must be those of a local user so,
create the user on the system that is running the Task and have that user
run the Task.

Jim
 
M

mpov via AccessMonster.com

Thanks Jim.
I had my IT team create a script to do the move.

I would still like to do this in Access if possible so I can eliminate this
extra step.

Jim said:
I do this type of thing with a .vbs script or a .bat script. After the
script is created and saved to a particulat folder on c:\, I create a
Scheduled Task to run the script. The Scheduled Task requires credentials.

I believe the user credentials you use must be those of a local user so,
create the user on the system that is running the Task and have that user
run the Task.

Jim
I have an Access process that pushes a csv file to a network drive. The
drive has a separate user name and pwd. Does anyone have code that can
[quoted text clipped - 3 lines]
Thanks in advance.
 
J

Jim Evans

The advantage to this method is that it runs regardless of whether your
Access app is open or not :)
Jim

mpov via AccessMonster.com said:
Thanks Jim.
I had my IT team create a script to do the move.

I would still like to do this in Access if possible so I can eliminate
this
extra step.

Jim said:
I do this type of thing with a .vbs script or a .bat script. After the
script is created and saved to a particulat folder on c:\, I create a
Scheduled Task to run the script. The Scheduled Task requires credentials.

I believe the user credentials you use must be those of a local user so,
create the user on the system that is running the Task and have that user
run the Task.

Jim
I have an Access process that pushes a csv file to a network drive. The
drive has a separate user name and pwd. Does anyone have code that can
[quoted text clipped - 3 lines]
Thanks in advance.
 
R

ryguy7272

Would something like this work for you?
http://www.iopus.com/guides/winscheduler.htm

HTH,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


Jim Evans said:
The advantage to this method is that it runs regardless of whether your
Access app is open or not :)
Jim

mpov via AccessMonster.com said:
Thanks Jim.
I had my IT team create a script to do the move.

I would still like to do this in Access if possible so I can eliminate
this
extra step.

Jim said:
I do this type of thing with a .vbs script or a .bat script. After the
script is created and saved to a particulat folder on c:\, I create a
Scheduled Task to run the script. The Scheduled Task requires credentials.

I believe the user credentials you use must be those of a local user so,
create the user on the system that is running the Task and have that user
run the Task.

Jim

I have an Access process that pushes a csv file to a network drive. The
drive has a separate user name and pwd. Does anyone have code that can
[quoted text clipped - 3 lines]

Thanks in advance.


.
 
Top