Error 3622. I have read that you must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column
We took an Access backend and uploaded it to SQL Server. Is there anyway it can be uploaded without an IDENTITY column? Out of the 30 or so tables many have autonumber fields as the PK. The Access Frontend linked to the SQL Server uses DAO. Please tell me that I won't have to go to each OpenRecordset and add dbSeeChanges. Can something be done in SQL Server instead?