Write conflicts on Access 2003/ODBC

  • Thread starter Thread starter Jim McDonald
  • Start date Start date
J

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
 
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
 
You should have a time stamp field on every table,
and Boolean fields must not allow null values.

(david)
 
Back
Top