odbc--update on a linked table failed

R

Rosco

my linked table to sql server keeps locking, after i have used a access front
end form to edit a record.
the problem is killing my app
 
K

Klatuu

There is no way to give you an answer based on the info provided.
The most likely case is that there is one or more constraints on the table
defined in the SQL Server database that is not allowing the update.
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Cannot do anything after zooming - Publisher Lite on Mac 0
Adding data to MS Access from csv file 0
replacing a link to a SQL Server table with VBA 0
Table of content - format does not get saved 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
ODBC Update on a linked table 'table name' failed 1
Why won't Access assign a Primary Key ID to my linked SQL Table? 2

Top