Map network from Access

[NNNNN]

Is it possible to map a network drive
when a button is clicked on a form in Access?

 

[KarMac21]

Try this:

Set WshNetwork = CreateObject("WScript.Network&quot
WshNetwork.MapNetworkDrive "H:", "\\Server\Share"

Hope this is what you were looking for.
Shane

 

[SBendBuckeye]

You'll need to ensure you have a reference set to Windows Scripting Host for KarMac21's code to work. In VB Editor, Tools, References, Windows Scripting Host, etc.

Good Luck!