ACCESS Table Conversion to SQL

[Rick]

I have an Access database that I have recenlty upgraded
the tables to SQL. Unfortunately the front end is still
in Access (I am more of a VB guy). My problem is that the
Access forms have subforms that allow users to enter and
modify data. However now that the tables are in SQL users
cannot add new records, the small "new record" button is
greyed out on the navigator and there are no empty fields
for them to add to.

Any help would be appreciated.

Thanks

Rick

 

[Ron Weiner]

The number one reason I have found for this problem after super-sizing a
happy meal is that the Access Autonumber (Primary Key) field was not set as
an "Identity" with and "Identity Increment" of 1 on Sql.

Ron W