DanceRat wrote:
> 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
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
Received on Tue Feb 24 2004 - 05:19:12 CST
