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