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

MS Access DAO multi-user updating problem

P: 1
Hi all,

I have an application developed in MS Access and using DAO and running in multi-user environment. It is not a Web application, just the users are sharing data source. My problem is when more than one users are working on same record they are overwriting each other, in another word if a record has been deleted or updated by other users since the user retrieved the record and the user without realizing the changes and update the record again!

Could anyone give me a clue how to solve this problem?

Thanks in advance

Rossy
Oct 25 '06 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,221
You have to look for the options about record locking. Under Tools, go to Options and the Advanced Tab. Set your default to lock the edited record. You also have this as a property option on forms.

Jim
Oct 25 '06 #2

Post your reply

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