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

Record Locking Error

P: 74
I have turned on record locking do to the fact that we are starting to have issues with the records not being locked. I have a button on a form that changes the recordsource of the form. When i started testing the record locking..... here is what i did.

1. Turned on record locking.
2. Renamed extension of database to accdr, so that it would open with runtime (so i could open multiple instances of it)
3. Opened the form (all records)
4. Opened the form again (2nd instance)
5. Pressed the button to change the recordsource on instance 1
6. Pressed the button to change the recordsource on instance 2 (so that the same record was active at the same time)
7. Got a runtime error on instance 2.

Usually when i get a runtime error (while using access runtime) i will change the extension back to accdb, open with regular access, try to duplicate the process and get the actual error. But i cant open multiple instances with access (on the same computer) so i cant actually get the error message to run for me.

Does anybody have any idea of what the error could be related to.

I have another form that accesses the same record from the same table. I opened it (regular access) while the original form was open, and it appeared to lock the record, so i couldnt get the error that way either.

As always... any help is appreciated.
May 5 '09 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,287
You'll need to add error handling to all functions to catch and report errors while in runtime rather than crashing. Take a look at Error Handling in VBA for a start, and let us know if you can't deal with the error once you figure out what it is.
May 5 '09 #2

P: 74
Thanks for the help!
May 15 '09 #3

Expert Mod 15k+
P: 31,709
Debugging in VBA may help as an alternative approach.

This would simply be for the development stage though. This is no substitute for properly handled errors in a live system, though it can provide more helpful information and understanding at the development stage.
May 25 '09 #4

Post your reply

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