MS Access 97 Connecting to MS SQL

  • Thread starter Thread starter Phichai
  • Start date Start date
P

Phichai

I am using Ms Access 97 on Windows XP Profession and use
MS SQL for the database by using MS Access 97 for
interface. I have got an error when do update query and
the error is "Operation must use an updatable query.
(Error 3073)". Actaully, I am using ODBC to connect to
SQL database and my Windows NT access has permission
dbowner.

Please kidnly suggest to fix the error.

Thanks & Regards,
 
Do you have a primary key defined for each of your SQL Server tables? ODBC
treats tables as non-updatable unless there's a primary key.
 
Back
Top