|
|
Posted by Erland Sommarskog on 12/12/06 22:49
(olle@ylm.se) writes:
> I have the problem that some records in a ms sqlserver table is unable
> to update from Access.
> I get the error message odbc-time out error in linked table......
> I tried to copy this table to another database, where none but me was
> aktive.
> And then it worked quit ok when I try to save the record.
>
> I am thinking about if there is some trigger och restraint that I
> don't know about, but I don't know how to se all of this in the
> database.
>
> I have changed the odbc-timeout settings in Access but that doesn't
> seed to make any difference
Could be a blocking issue. You can check this in Query Analyzer by
running sp_who2. If there is a non-zero value in the Blk column,
that spid is blocking the spid on that line. With the rest of the
information from sp_who2, you may be able to identify the blocker.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|