Thank you sooooo much!!!!!!
It works great!!!! It actually need Both PK and Unique Index to be in the database.
I was just kinda wondering how come SQL Server was able to recognize the records without PK and Unique Index when the origninal .mdb upsized to SQL Server DB.
Now, I'm trying...
Yes, I did relink the table sucessfully in Access using Linked Table Manager after setting Primary Key. However, the data is still not updateable.
One thing I'd like to mention is I take the backup of SQL Server database and restore it to a new Server. Then, relink the Access application to...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.