Access update query error

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.
 
J

Jeff Boyce

Check Access HELP on "updatable queries". When you get that error message,
you can sometimes modify the query to include respective keys.
 
J

JohnFol

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

query is not updatable;; urgent 1
update query ODBC--call failed 3
update query on a JOIN Table with a query Not Work 1
Using ODBC Connection Query Error: Non-Updatable Query 4
Update Query Fails due to Source table not being Updatable 2
ODBC -- update on a linked table [table name] failed 1
SQL Query UPDATE & SELECT COUNT does not work 1
Updating the 1 side of a 1:Many Relationship 3

Top