linked tables read only

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top