I'm working on a contact management database. At some point I'm sure more then one person will try to access it at the same time. I don't fore see the need for two people to need to edit the same record at the same time, but multiple people might need to edit records that are stored in the same table at the same time.
Any suggestions? All answers are greatly appreciated!
2006-12-14 06:34:49 · 3 answers · asked by Kristi 2 in Computers & Internet ➔ Software
1) Put the database (the .MDB file) on a network or shared location.
2) For each person who might be using the database, configure their Access installation so that they don't open the database in Exclusive mode. Then you should be good to go.
2006-12-14 06:46:36 · answer #1 · answered by Navigator 7 · 0⤊ 0⤋
Each user need to have full read and write rights to the file and to the folder the data file exist. This is because access create a .ldb file as soon as a user open the database. If the other users can't access this same file they will not be able to open the data. This .ldb file is used for locking records.
Access versions of all the users, accessing the same data file must be exactly the same. This is because each version .ldb lock file differ slightly.
2006-12-14 06:55:08 · answer #2 · answered by V 5 · 0⤊ 0⤋
Edit different records no problem - the same record a recipe for disaster.
2006-12-14 06:41:15 · answer #3 · answered by derf 4 · 0⤊ 0⤋