ODBC Update on a linked table 'table name' failed

  • Thread starter Thread starter davidt4e
  • Start date Start date
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
 
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
 
Back
Top