Updating Tables in SQL Server

[redbirdofthesouth]

I am moving some Access applications to a client/server configuration using SQL Server. Some of the tables (and not all) are not allowing adds or deletes. Others allow. The one
s that do not generate the error message "Can't go to specified record", in other words the table will not allow me to go to the next empty row for adding data. When I try to delete nothing happens at all. As part of an experiment I have built the user forms to do the adds and deletes just using Access wizards, the code is identical. I have checked the permissions on the tables and the database in SQL Server and they appear identical for tables, roles, users and database. I have checked the properties on the userforms and again they appear identical. Anyone encountered this before or know how to deal with it?
Thanks!

 

[jmeadows7]

I have seen this type of behavior in the past when no uniquer record key was specified on the SQL Server table. Do the tables on which the commands do not work have unique primary keys defined?