linked tables read only

G

Guest

Hi,
I linked the SQL Server 2000 tables on the Access Database (version 2003).
Some of the tables are read only and some of them I can add the record but
cannot update or delete. I connect to SQL Server via ODBC connection, File
DSN.
Thanks in advance
karakas
 
V

Vinayak N

Hi,

First please check if there is a primary key for every table that you
are having a problem with. Mostly a lack of primary key gives this
problem.

Regards,
Vinayak
 

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

Linked SQL Tables don't report Cascading Updates and Deletes 2
Best way to deploy Access read-only database that is linked to SQL tables 6
Record-Locking remains open after closing 0
ODBC Linked tables keep on getting error 3151 5
Write Conflict in Access with SQL server Tables 3
Using ODBC Linked Tables 10
SSMA linking Tables 4
MDB with only linked tables growing tremendously 15

Top