Insert on Linked Table

[Guest]

I have a table in SQL Server 6.5 that I access via my Access 97 code through
a linked table via an ODBC connection. The table has a primary key that is
an identity field and several other fields (varchar, int, decimal and
datetime datatypes). My users have been writing to this table for months.
However, today for about 15 minutes, users received the following error:
Run-time error '3155' ODBC--insert on a linked table 'tblName' failed. I had
them get out of the application and go back in and everything seems to be
working fine now. I checked my SQL Server logs but could not find anything
unusual. However, I'm worried about what caused this error and why was it
only this table that had the problem. Any information would be greatly
appreciated. Thanks

 

[Albert D.Kallal]

About the only thing I can think of is if you are allowing more then one
person in the front end.

You need to place a copy of the mde file on each computer (you are using a
mde..right?).

 

[Van T. Dinh]

It is possible that some process places a lock on the Table at the time and
users won't be able to enter data.

There are also dead-locks and blocking connections that will prevent users
from entering data.

Check SQL B.O.L. on dead-locks and blocking connections.

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

Each user downloads a copy of an MDB file to their machine and they use this
to access the data. There could be up to 75 users at once hitting the
database. This particular table that received the error, only about 20 users
max would be hitting it at once.

 

[Guest]

Thanks for the info, I'll check it out.
--
JKro

It is possible that some process places a lock on the Table at the time and
users won't be able to enter data.

There are also dead-locks and blocking connections that will prevent users
from entering data.

Check SQL B.O.L. on dead-locks and blocking connections.

HTH
Van T. Dinh
MVP (Access)