Opening a database while in another database

[ddonia]

Is there anyway to open a database, through code or otherwise, while i am in another database?

we are hoping to add this to the bottom of a macro that is updating some tables in an external database. when all of the updates are done, we are hoping to have the external dbase open.

is this possible?

thanks!

 

[oharab]

There are 2 ways:
If you know where the Access file is stored then:
shell "path\to\access.exe path\to\database.mdb"
will do it.

Alternatively you can use the code in faq705-1971 and go:
fHandleFile "path\to\database.mdb",WIN_MAX


hth

Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------