I created a SQL Server database and imported some tables from another SQL Server database but I can't edit or insert data in those imported tables. What do I need to do to fix this? All these tables will be linked to an Access frontend. This issue is time sensitive. Thank you for any help with this.
hi
hope this helps
it might be a permissions issue
the user that you logged in as
can be given data read data write data modify
( among a whole slew of other permissions )
by the admin or sysadmin or superadmin
Thank you for responding.
I found the problem. I didn't realize that when I export a table from one database to another, the primary key is not exported also. Using T-SQL I re-created the primary keys in the imported tables and I was then able to edit records and insert new ones.