Log on to shared netword drive programmatically

[Kwixster]

I have an Access application that needs to access files on a network drive.
Every night the client turns off his computer and then back on in the
morning. When my Access app tries to find the file in the morning he gets
the error "Path/File access error" (error 75). To fix this he opens Windows
Explorer, selects "My Network Places" and the server name. Then he's asked
for his user name and password (which he enters). Now everything works fine.

Is there a way I can respond to this error by providing the user name and
password through VBA code?

Thanks in advance for any replies.

 

[Alex Dybenko]

try to use NET USE with shell()

type NET USE ? at command prompt for more info

 

[Kwixster]

Thanks! That's exactly what I needed. Works like a charm.