SQL Server Permissions

[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

 

[Alex]

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

 

[Ryan Langton]

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