Write conflict on new records since switching to SQL Server backend
Posted on 2004-04-02
I have a MS Access 2K front end and just switched to SQL Server 7 backend.
I imported the data from the prevous MSAccess backend and I had to set the primary keys and Identity fields in SQL Server.
I can open the front end and edit any old data, but if I create new data, I get the "Write Conflict" error message and cannot save the changes. (I am the only one trying to work in these databases)
The only options are drop changes and save to clipboard.
I also get the error if I try to delete a record. May be Referential Integrety issue ?
I am linking tables (ADO) as SQL authenticated user. I expect there may be a permissions or property setting that needs to be changed in the database or tables.