Hi, all,
I'm read the thread on Lined MS Access table Not Updateable, which is really great!!!
I have an Access .mdb file with a linked table to SQL Server 2K. When trying to update/add record in Access, it shows: the recordset is not updateable.
I checked the Primary Key Constraint in both Access and SQL Server. There were No Primary Key. Therefore, I set the primary key in the table in SQL Server and also the corresponded table in Access.
However, The data are still not updateable through Access. Does anyone have any idea on how to make the data updatable through MS Access?
Thank you sooooo much~~~
Steph
I'm read the thread on Lined MS Access table Not Updateable, which is really great!!!
I have an Access .mdb file with a linked table to SQL Server 2K. When trying to update/add record in Access, it shows: the recordset is not updateable.
I checked the Primary Key Constraint in both Access and SQL Server. There were No Primary Key. Therefore, I set the primary key in the table in SQL Server and also the corresponded table in Access.
However, The data are still not updateable through Access. Does anyone have any idea on how to make the data updatable through MS Access?
Thank you sooooo much~~~
Steph