PC Review

Thread Tools Rate Thread

ODBC Update on a Linked table failed

Posts: n/a
      17th Nov 2006
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?
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC Update on a linked table 'table name' failed davidt4e@hotmail.com Microsoft Access Form Coding 1 30th Jun 2010 06:38 AM
ODBC -- update on a linked table [table name] failed Tim Microsoft Access Queries 1 1st Jul 2009 09:34 AM
Error 3157: "ODBC - update on a linked table <table name> failed Jannah Microsoft Access 4 5th Sep 2008 08:44 PM
ODBC Update failed on linked table Robert Kewan Microsoft Access ADP SQL Server 0 12th Feb 2004 03:14 AM
UPDATE a linked access table with value from a ODBC linked SQL table JB Microsoft Access 0 18th Nov 2003 10:27 PM




All times are GMT +1. The time now is 09:31 PM.