Avatar of frimy
frimy
Flag for United States of America

asked on 

Acces SQL Insert Problem

Hello All,
We have a Access FE and SQL BE (2008 sql express windows server 2012) and the database was working flawlessly more then two years.
Now we have a problem with one table (not a large table 17 fileds and 125,000 records)
I m adding records in a loop i.e eight records, the system will add 3 or 4 recs and will stop with msg "ODBC -- Insert on linked table TableName failed"
I already had a professional SQL guy looked at the problem with many sql commends, the profiler doesn't show anything because the sql "stops and locks in a stand still with no indication and any hint why it stopped.
He said it looks like a locking issue but he cant see why and who is locking the table.

Thanks in advance it's very important.
SQLMicrosoft SQL Server

Avatar of undefined
Last Comment
frimy

8/22/2022 - Mon