Opening another Access instance

[Terry]

I need to open another instance of Access with a specific database, without
closing the currently open database. What is the best bit of Vba to use?

Regards

 

[Guest]

One way is the SHELL command. You have to be careful with the spaces in
your file paths.

Here's an example that works:

Shell "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" & " " &
"C:\Docume~1\Steve.DOMAIN\MyDocu~1\DATA\Sample.mdb"

Steve

 

[Ben O'Hara]

Or you could use the code from: http://mvps.org/access/api/api0018.htm

which you just pass the name of the file you wnant to open. You don't need
to know where msaccess.exe is on your system.

hth

Ben

 

[Terry]

Thanks for the replies,

I took a look at the Automation Whitepaper and found something in the help
files that with a little bit of bending did the trick.

Regards

 

[Terry]

Thanks for that one Ed. Didn't consider that.
Regards