I am linking to an SQL Server 2008 table in an Access 2010 database.
I am able to update existing data in this linked table but am unable to add records.
I have done the following:
1) created a timestamp field in the SQL table
2) created a field in the SQL table with a data type of "int" and the identity specification set to "Yes". (This becomes an "AutoNumber" field in the linked Access table).
3) have created a unique index on the field referred to in step 2. (This becomes a Primary index in the linked Access table).
4) Have given myself Delete, Insert, Select and Update permissions in SQL Server for the table.
I've set up and linked to many tables like this before and have never had a problem. Any ideas on what I could be missing?