Mapping a shared drive On open of a form (Access 2000)

Topic

New Reply

Is there a way to map a network drive on the On Open event (or some other event) when a form is open. The drive mapping is sever1FS_ADM_Data_06$. Really in a bind here. Thanks..

Reply | Quote

Replies

What exactly are you trying to do? If you know the UNC of the map, then you can use that all along.

Reply | Quote

The UNC is sever1FS_ADM_Data_06$. I need the user to map to this when they open the form. This where the main table for the form is located. Does this make sense?

Reply | Quote

Not really. Is the table in a database or is it some kind of external file? Is this the connect path for a linked table, or what? Access doesn’t need mapped drives, it works just fine with UNC paths, so what you’re trying to do isn’t clear. Are you trying to bind the form to a file in that location? If so, it won’t work. You can bind a form to a table or query or a stored procedure but not to a file.

Reply | Quote

With the obvious questions of why you want to do this aside, here’s how.

net use T: MyServerMyShare

Just make a string with that command and shell it.

Reply | Quote