Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 653
  • Last Modified:

Access Database - prevent multiple user simultaneous write access

I'm a complete novice with Access, and did not build the database in question, but it appears whoever did set it up so multiple users can have write access at the same time.

This is causing a lot of problems, as people change records then save it, sometimes overwriing over peoples work.

Anyone know how I can reverse this so any user who tries to open the DB while someone else has write access is presented with a pop up saying read only is available, and telling them who else has it open?

thanks,
0
EffEffTee
Asked:
EffEffTee
1 Solution
 
slam69Commented:
You can set the database to open exclusively in tools, options advanced default open mode

however this means only one person can open it at a time which might be counter productive

better way would be to develop code to lock the records in question and stop multiple users accessing same record, or just try the simple default record locking in same area as above
0
 
EffEffTeeAuthor Commented:
thank you!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now