Open multiple copies of same access database.

[joejack0330]

We have been running a lot of access 2000 databases on mostly windows 2000 machines and as we are upgrading to Windows Vista (Happens on XP too) along with Access 2007, when a user tries to open a second copy of the same
database (or any office document), it just makes the original one they have open the active window but does not open a new copy. On Office 2000, it might give a message about it being read only but still would open. Not a
major issue but a lot of users sometime like to have 2 copies open if they are working on different screens and since these are mostly access .adp's, it doesn't hurt because data is stored on sql server. Is this something that we can change? Thanks, Joe

 

[joejack0330]

Just to update, I think I found a way around it. Rather than having their shortcut point to the .adp itself, for example buyingdept.adp, if I do it like below, it works. It gives a message about read only for 2nd and so on copies but since they are not updating anything in database itself, it should be good.

"C:\Program Files\Microsoft Office\Office12\msaccess.exe" "c:\program files\buyingdept\BuyingDept.adp" /runtime