ODBC Update on a linked table 'table name' failed

D

davidt4e

Hello!

I am getting an error on a form that is built in Access 2003 with an
SQL Server backend that is a form/subform construct. The full text of
the error is:

ODBC Update on a linked table 'table name' failed.
[Microsoft][ODBC SQL Server Driver] Timeout expired (#0)

I imagine that this is due to a locking (or is it blocking? I'm a
newbie here) issue with the form and subforms. (And yes, it's plural
subforms.) How do I troubleshoot them? Are there default settings
that I can use for this?

Thanks in advance.

David
 
T

Tom van Stiphout

On Tue, 29 Jun 2010 10:57:46 -0700 (PDT), (e-mail address removed) wrote:

I would run:
exec sp_who
on the sqlserver, and the results will tell you if there was any
blocking going on. Typically when there is, you will also get a
"deadlock victim" error.
I may also want to run the sqlserver Profiler application, to watch
the traffic from the Access app.

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top