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