Access 97 - Multiuser problem

Hello all,

We are using A97-SR2 and XP.

The problem is (simplified):
- We've got an A97 db (say "a97.mdb") on a file server (say "S").
- Many persons need to access this database at a same time (say "P1", "P2"
and "P3")
- P3 is different from P1 and P2 only in the fact that he is in the
administrators group on his PC.
- P1 and P2 can only open the a97.mdb if nobody has opened it (including
themselve: they cannot open it twice at the same time)
- P3 can open a97.mdb at any time without restriction.
- If P1 or P2 open a97.mdb the P3 open it, they can continue to work without
any problem.
- No error message is generated, nor at screen neighter in the system or
application log. Nothing is appening. Double-clique the file... nothing.
- P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
directory where it is stored.
- As expected, a97.ldb is always created when one of them open a97.mdb for
the first time.

Well. I hope it's clear. Anybody can tell me how to solve this problem, and
give concurrent access to the DB?

Thanks

Yannick

P1 and P2 don't have their default set to open exclusively, do they? Check
the Advanced tab under Tools | Options.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Yannick Turgeon" <nobody@nowhere.com> wrote in message
news:B8B7e.5471$MZ2.805401@news20.bellglobal.com.. .[color=blue]
> Hello all,
>
> We are using A97-SR2 and XP.
>
> The problem is (simplified):
> - We've got an A97 db (say "a97.mdb") on a file server (say "S").
> - Many persons need to access this database at a same time (say "P1", "P2"
> and "P3")
> - P3 is different from P1 and P2 only in the fact that he is in the
> administrators group on his PC.
> - P1 and P2 can only open the a97.mdb if nobody has opened it (including
> themselve: they cannot open it twice at the same time)
> - P3 can open a97.mdb at any time without restriction.
> - If P1 or P2 open a97.mdb the P3 open it, they can continue to work
> without any problem.
> - No error message is generated, nor at screen neighter in the system or
> application log. Nothing is appening. Double-clique the file... nothing.
> - P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
> directory where it is stored.
> - As expected, a97.ldb is always created when one of them open a97.mdb for
> the first time.
>
> Well. I hope it's clear. Anybody can tell me how to solve this problem,
> and give concurrent access to the DB?
>
> Thanks
>
> Yannick
>[/color]

Are they all trying to open the same mdb file on a server? You might want
to consider splitting the db into front and back ends and giving each user
their own front end. Also, all users need read/write/execute/delete
permissions to the parent folder.

HTH - Keith.
www.keithwilby.com

"Yannick Turgeon" <nobody@nowhere.com> wrote in message
news:B8B7e.5471$MZ2.805401@news20.bellglobal.com.. .[color=blue]
> Hello all,
>
> We are using A97-SR2 and XP.
>
> The problem is (simplified):
> - We've got an A97 db (say "a97.mdb") on a file server (say "S").
> - Many persons need to access this database at a same time (say "P1", "P2"
> and "P3")
> - P3 is different from P1 and P2 only in the fact that he is in the
> administrators group on his PC.
> - P1 and P2 can only open the a97.mdb if nobody has opened it (including
> themselve: they cannot open it twice at the same time)
> - P3 can open a97.mdb at any time without restriction.
> - If P1 or P2 open a97.mdb the P3 open it, they can continue to work
> without any problem.
> - No error message is generated, nor at screen neighter in the system or
> application log. Nothing is appening. Double-clique the file... nothing.
> - P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
> directory where it is stored.
> - As expected, a97.ldb is always created when one of them open a97.mdb for
> the first time.
>
> Well. I hope it's clear. Anybody can tell me how to solve this problem,
> and give concurrent access to the DB?
>
> Thanks
>
> Yannick
>[/color]

Well, I solved the problem addind "S" IP to the "Trusted sites" list:
http://windowsxp.mvps.org/networkfile.htm

I don't really know why it's working. When P1 and P2 were opening a97.mdb,
they was getting a warning message, not P3. We've got use of it. Probably
this security check was causing some kind of error when trying to open an
already opened db.

Thanks to those who replied.

Yannick


"Yannick Turgeon" <nobody@nowhere.com> wrote in message
news:B8B7e.5471$MZ2.805401@news20.bellglobal.com.. .[color=blue]
> Hello all,
>
> We are using A97-SR2 and XP.
>
> The problem is (simplified):
> - We've got an A97 db (say "a97.mdb") on a file server (say "S").
> - Many persons need to access this database at a same time (say "P1", "P2"
> and "P3")
> - P3 is different from P1 and P2 only in the fact that he is in the
> administrators group on his PC.
> - P1 and P2 can only open the a97.mdb if nobody has opened it (including
> themselve: they cannot open it twice at the same time)
> - P3 can open a97.mdb at any time without restriction.
> - If P1 or P2 open a97.mdb the P3 open it, they can continue to work
> without any problem.
> - No error message is generated, nor at screen neighter in the system or
> application log. Nothing is appening. Double-clique the file... nothing.
> - P1, P2 and P3 have write/exec/read on both the a97.mdb file and the
> directory where it is stored.
> - As expected, a97.ldb is always created when one of them open a97.mdb for
> the first time.
>
> Well. I hope it's clear. Anybody can tell me how to solve this problem,
> and give concurrent access to the DB?
>
> Thanks
>
> Yannick
>[/color]