opening multiple instances of MDB file on one PC

D

Doug Goodenough

Hello,

I can open the same MDB file multiple times with access 97 on the same
computer. After converting the MDB file to access 2003 format I can no
longer do this. Is there a setting somewhere I can change to allow the MDB
file to be opened multiple times on the same machine?

Thanks much,
Doug
 
A

Albert D.Kallal

I can't remember the default behavior of a97.

If there was a change, then my guess is that the change was made, since many
users wind up opening the same copy over and over.

By the end of the day...they got a zillion copies open....

If you launch ms-access again, then you can go file->open

So, you can accomplish this via launching another copy, but clicking on the
same database don't do it...

If you also build a shortcut icon to msaccess.exe (which you must do if you
are using workgroup shortcuts, then again, you can launch as many copies by
simply clicking on the icon...

So, a shortcut like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"c:\program files\RidesXP\RidesXP.mdb"
/wrkgrp "c:\Program Files\RidesXP\Rides.mdw"
/User "RidesAdmin" /pwd "mypassword"

Of course, if you don't use workgroup, then remove that stuff. So, making a
shortcut should allow you to launch the application more easy then launching
ms-access, and then going file->open....
 
Top