How to open an access database with a .vbs file 1

[t1hodges]

All I want to do is open an existing .mdb by double-clicking a .vbs file.

if the location of the .mdb is "c:\Destop\example.mdb" how should I create the vb code in notepad?

Thanks a bunch.

 

[DANZIG]

Are you wanting to open and have a script process data from the mdb or jus have MS Access open the specified file in an interactive mode?


Thanks, Danzig

 

[PHV]

Something like this ?
Set Sh = CreateObject("WScript.Shell")
Sh.Run """\path\to dir\example.mdb"""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[t1hodges]

This worked like a charm PHV. Thanks again!