Multiple Users, Access 97, locked DB problem

Multiple Users, Access 97, locked DB problem

Post by damse » Wed, 25 Feb 2004 02:42:14


Here is the deal. We have three machines running Access 97 against a
Oracle 9i backend. 8.1.7.4 drivers. Each client can link to the
database, but while that client is in, the others are not able to get
in. The client unlinks from the database, the other client can get in
- but only one at a time. The database had no problems of this nature
until recently when a table was added. Can anyone shed any light?

Thanks
 
 
 

Multiple Users, Access 97, locked DB problem

Post by Andrew Har » Wed, 25 Feb 2004 20:19:12


Presumably the new table being added means that new DML is being
performed by the Access system? If so, check it for the obvious errors
e.g. selecting for update at the start of a long transaction.

--
Andy - Opinions are mine and do not necessarily reflect those of
Advantica Ltd