By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

The data has been changed error message

P: 1
I noticed that the "The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record" message has been dealt with in this forum. I am updating a file when a command button on Form A is clicked, and then displaying Form B. When a field on Form B is changed, I am receiving the above message. I am updating using SQL statements rather than a recordset. What should I do so that this message doesn't occur?
Thank you in advance for your advice and help,
TracySHC
Nov 21 '08 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,597
Try changing your Locking Strategy, perhaps:
  1. Open Databases using record-level locking.
  2. Lock Edited Record (Pessimistic Locking).
  3. Both of thes Options can be found under:
    Expand|Select|Wrap|Line Numbers
    1. Tools ==> Options ==> Advanced
Nov 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.