Permissions problem

Copper Contributor

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 tables.  I don't know what I need to adjust to allow editing and additions.  Can someone please help?  This is pretty time senstive.  Thanks.

3 Replies

 


but I'm not able to edit or insert any data to the linked tables. 

@Euler314 "not able" means what in detail? Do you get an error message and if, which one?

"Edit" is a strange context in context of SQL Server. Do you mean edit in a GUI of SSMS? Of course not possible.

You have to execute DML commands against the linked server.

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.
A primary key is for MS Access mandatory, otherwise you can modify anything.