Link to home
Start Free TrialLog in
Avatar of dpalyca
dpalyca

asked on

MS ACCESS, write conflicts, update queries!

When I run an update query from a form I get an write conflict message stating that the record has been changed by another user since I started editing it.   I am the only user of this database this far.  If I run it from the query menu on its own it works fine!  Any ideas?
Avatar of SjoerdVerweij
SjoerdVerweij

What does the update query do? You can directly access the data in the record you are working on in code.
Avatar of rockiroads
whenu run this update query, have you got the table open? either thru recordset or something
what is the locking policy Tools/Options/Advanced
ASKER CERTIFIED SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial