MS Access 97 Connecting to MS SQL

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,
 
D

Douglas J. Steele

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