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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write Conflict 8
Write conflict 5
cant edit in my form, write conflict problem? 2
write conflicts 1
Access97 "Write Conflict" 3
write conflict 3
write conflict 2
Close Access application remotely ODBC issue 1

Back
Top