By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Can open DB multiple times but only on one PC

P: n/a
Hi All,
I have an MS Access DB (2003) with frontend on PC (xp) and backend on
Server (2003). I can open multiple instances from this PC. I make a
duplicate copy of the MS Access DB and put it onto another PC and I
can only open one instance. Does anyone know what would be preventing
it from opening multiple time on the one PC but not on the other. I am
NOT using an MDW file and the shortcut target is just:
C:\Volunteer\Volunteer.mdb

Thanks for your input.

Cheers,
Barry
Jan 4 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Barry Edmund Wright wrote:
Hi All,
I have an MS Access DB (2003) with frontend on PC (xp) and backend on
Server (2003). I can open multiple instances from this PC. I make a
duplicate copy of the MS Access DB and put it onto another PC and I
can only open one instance. Does anyone know what would be preventing
it from opening multiple time on the one PC but not on the other. I am
NOT using an MDW file and the shortcut target is just:
C:\Volunteer\Volunteer.mdb

Thanks for your input.

Cheers,
Barry
What happens if you open Explorer, get to C:\Volunteer, and right click
on Volunteer.mdb, and select Open?

SuzieQ
http://www.youtube.com/watch?v=8Un8vgJzFqg
Jan 5 '08 #2

P: n/a
Sounds like the first PC is opening in Shared mode, but the other one is
opening Exclusive.

Check the Default Opening Mode setting under Tools | Options.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Barry Edmund Wright" <bw**************@sympatico.cawrote in message
news:2d**********************************@i7g2000p rf.googlegroups.com...
Hi All,
I have an MS Access DB (2003) with frontend on PC (xp) and backend on
Server (2003). I can open multiple instances from this PC. I make a
duplicate copy of the MS Access DB and put it onto another PC and I
can only open one instance. Does anyone know what would be preventing
it from opening multiple time on the one PC but not on the other. I am
NOT using an MDW file and the shortcut target is just:
C:\Volunteer\Volunteer.mdb

Thanks for your input.

Cheers,
Barry
Jan 5 '08 #3

P: n/a
On Jan 4, 8:07*pm, Salad <o...@vinegar.comwrote:
Barry Edmund Wrightwrote:
Hi All,
I have an MS Access DB (2003) with frontend on PC (xp) and backend on
Server (2003). I can open multiple instances from this PC. I make a
duplicate copy of the MS Access DB and put it onto another PC and I
can only open one instance. Does anyone know what would be preventing
it from opening multiple time on the one PC but not on the other. I am
NOT using an MDW file and the shortcut target is just:
C:\Volunteer\Volunteer.mdb
Thanks for your input.
Cheers,
Barry

What happens if you open Explorer, get to C:\Volunteer, and right click
on Volunteer.mdb, and select Open?

SuzieQhttp://www.youtube.com/watch?v=8Un8vgJzFqg
After I have the volunteer.mdb database open and then open Explorer,
go to C:\Volunteer, and right click on Volunteer.mdb, and select Open,
I am taken to the open Volunteer database window.
Jan 6 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.