Write conflicts on Access 2003/ODBC

[Jim McDonald]

Hi all
I have a simple system that connects to a remote SQL Server DB via ODBC
under Win XP Pro. When I try to update data in a table (even from simply
viewing the table) I get a Write Conflict Error, and canno save the changes.
There is no one else attached to the db..
I can't find anything in the KB about this.. anyone got any ideas??
Thanks
Jimbo

 

[Guest]

Are you making changes to records using code if so I'd suggest saving the
record at some point. I had this problem with just Access and I used
RunCommand (acCmdSaveRecord) it cleared it up for me.

HTH
Martin J

 

[david epsom dot com dot au]

You should have a time stamp field on every table,
and Boolean fields must not allow null values.

(david)