troubleshooting Question

Acces SQL Insert Problem

Avatar of frimy
frimyFlag for United States of America asked on
SQLMicrosoft SQL Server
6 Comments1 Solution118 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros