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