Forum Discussion
Permissions problem
I have an Access database that is linked to a SQL Server database that I created. I imported some tables from another SQL Server database but I'm not able to edit or insert any data to the linked ta...
Thank you for responding.
The tables are linked to an Access frontend. By "edit" I meant changing the data in the tables from within the Access frontend.
I found that the problem was that when I imported the tables to the second SQL Server database, the primary keys were lost. I didn't know that. I had to recreate the primary keys and after I did that then I was able to edit the records within Access and insert new ones.
The tables are linked to an Access frontend. By "edit" I meant changing the data in the tables from within the Access frontend.
I found that the problem was that when I imported the tables to the second SQL Server database, the primary keys were lost. I didn't know that. I had to recreate the primary keys and after I did that then I was able to edit the records within Access and insert new ones.
A primary key is for MS Access mandatory, otherwise you can modify anything.