Access update query error

  • Thread starter Thread starter dgrazioso
  • Start date Start date
D

dgrazioso

I am trying to run an update query joining two tables.
One is a linked table through ODBC and one is a local
table. I get an error that the query is not updatable -
error 3073. I am using Access XP in 2000 mode. Thanks.
 
Check Access HELP on "updatable queries". When you get that error message,
you can sometimes modify the query to include respective keys.
 
You may also want to rule out any issues with the ODBC driver / cursors /
mandatory data by just adding a record to one table first.
 

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

update query ODBC--call failed 3
Update query issue 0
SQL Query UPDATE & SELECT COUNT does not work 1
Update Query 1
ODBC -- update on a linked table [table name] failed 1
Update Query Fails due to Source table not being Updatable 2
Updating the 1 side of a 1:Many Relationship 3
UPDATE Query 3

Back
Top