Write Conflict Error

[botts121]

Ok here is my problem. I have a database that connects to tables through a ODBC connection (if this matters or not) and the forms are local on each persons computer. If they happen to be on the same record they get a "Write Conflict" error. Does anyone happen to know how this could be fixed? Basically if one person is in editing a record, anyone else that enters that record I would like some message to come up and tell them that this record is being edited. And then Access kicks them out. So they can't enter that record while the other person is editing it.



Thanks in advance,

Matt

[RuralGuy]

Are you using error handling to catch the error?

[botts121]

No. But I got the problem fixed anyways.

Thanks,

Matt

[RuralGuy]

Care to share your solution with others that view this forum?

[botts121]

I only made it so that the "Write Conflict" message doesn't come up anymore.
They are still able to go into the same record, but the message doesn't come up anymore and doesn't give them an error and then kick them out of access all together.
The fix was, on the server side (table side), in the field named "TIMESTAMP", I had it set to INT(11). But the fix is to change it from INT(11) to just TIMESTAMP. This got rid of the "Write Conflict" error for me.

Hope this can help other people in the future,


Matt

[RuralGuy]

Thanks for sharing. Do you want to go ahead and mark this thread Solved with the thread tools?