troubleshooting Question

Write conflict on new records since switching to SQL Server backend

Avatar of reprosser
reprosser asked on
Microsoft SQL Server
18 Comments1 Solution3735 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 18 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros