SQL Server Permissions

  • Thread starter Thread starter Ryan Langton
  • Start date Start date
R

Ryan Langton

I believe I am having a permissions issue with a SQL server migration. I
have migrated all my tables from one SQL server to another (different
hardware server). I changed the connection properties on my .adp to access
the data on the new server. The data is there and it appears that I have
permissions to change table layouts (add/remove fields) and even create or
delete forms/queries/tables/etc, but I cannot add/edit/delete any of the
data. Can anyone point me in the right direction?

Thanks,
Ryan
 
Hi Ryan,

the main reason for and inability to update/add/delete data is the lack
of primary keys and identity columns, can you modify the data through
the SQL enterprise manager?

check your primary keys.

hope it helps.

Regards

Alex
 
Ug! To think I struggled with this for hours this morning and it's something
as simple as primary keys! That did it, thanks :)

Ryan
 
Back
Top