ODBC Update on a Linked table failed

Discussion in 'Microsoft Access Forms' started by Guest, Nov 17, 2006.

  1. Guest

    Guest Guest

    I created a form in Access 2003 who's recordsource is an ODBC linked table from
    SQL Server 2000. The form has a subform that lists all the records in that
    table. The form also has all the fields from that table as separate controls.
    I have a command button to add new records, which works without any
    problems. When the user clicks on any record in the subform, I fill in the
    controls on the form, and this works fine. But If I try to edit anything in
    the record, when it tries to update the record, I get this message , ODBC
    Update on a linked table "Table Name" failed - [Microsoft][ODBC SQL Server
    Driver]Timeout expired(#0). It also takes 1-2 minutes before this message
    appears. If I remove the subform or if I use a table thats not linked for the
    recordsource, it works fine. What am I doing wrong?
     
    Guest, Nov 17, 2006
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rich
    Replies:
    4
    Views:
    223
    Albert D. Kallal
    Oct 4, 2004
  2. Guest
    Replies:
    0
    Views:
    1,064
    Guest
    May 24, 2006
  3. golfinray
    Replies:
    0
    Views:
    511
    golfinray
    May 20, 2009
  4. Tim

    ODBC upate on a linked table failed

    Tim, Feb 8, 2010, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    400
  5. nani
    Replies:
    0
    Views:
    1,054
Loading...

Share This Page