Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Location
    Missouri
    Posts
    25

    Unanswered: Access2000 locking up on SQL Server Update

    I have a series of linked tables with an access db. When I alter the information on the linked table while in access, access then locks up and return an error:

    ODBC--update on a linked table 'dbo_AllPlants' failed.
    [Microsoft][ODBC Sql Server] Timeout expired(#0).

    I've double checked the permission and updated all links, any Ideas??

  2. #2
    Join Date
    May 2006
    Location
    Missouri
    Posts
    25
    I've been reading about the issue thought-out the web and have found some interseting post's thattake about this issue.

    http://www.mcse.ms/archive166-2005-6-1640151.html

    I am able to update the SQL Server within Access after working hours.
    I.E. 8pm - 5am
    Now I'm completely confused. Does anyone have an suggestions?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •