Write Conflict

[primagic]

I am using SQL as a backend with Access front end. I have a stored procedure which selects records from a table

This stored procedure is the source for a form. WHen I try to update a field i always get a write conflict. I have added timestamps to all the tables and look at the bit fields and still get the issue.

Any ideas?

 

[SQLSister]

Add an autogenerated id column as a PK

"NOTHING is more important in a database than integrity." ESquared

 

[primagic]

there is a PK which is autogenerated

 

[danvlas]

What is the exact error message?
Are you trying to save the record through some code or you're just moving out of the record?



Daniel Vlas
Systems Consultant