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

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

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" <bwright_msaccess [at] sympatico.ca> wrote in message
news:2df763ec-3aa3-42ba-b21a-0e2f4f0cb1d1 [at] i7g2000prf.googleg roups.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

On Jan 4, 8:07=A0pm, Salad <o... [at] vinegar.com> wrote:
> 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=3D8Un8vgJzFqg

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.