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.
 

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

SQL Connection Error with MS Access 7
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Query Error 3073 2
Slow response from MS access report 4
Database converison Access 97 to SQl server 3
SQL security permissions 1
Username and Password Pop-Up 4
HOW TO MAKE CONNECTION ON SQL SERVER USING MS ACCESS AS A PLATFORM 4

Top