•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 456,515 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,713 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 5547 | Replies: 5 | Solved
 |
•
•
Join Date: Jan 2007
Posts: 36
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
We have a MS Access database located on a shared drive. Is there a way I can allow multiple users to access and update the database at the same time?
•
•
Join Date: Jan 2007
Location: Oxfordshire, England
Posts: 307
Reputation:
Rep Power: 2
Solved Threads: 14
Posting Whiz
Hi,
There are ways, but you need to consider carefully what simoutaneous updating you wish to do.
For example if you have a database of names and addresses and two people wish to update it at same time, then if they wish to update different records, no problem should occur. However if they try and update same record then which one is correct ?
What do you have in mind ?
Denis
There are ways, but you need to consider carefully what simoutaneous updating you wish to do.
For example if you have a database of names and addresses and two people wish to update it at same time, then if they wish to update different records, no problem should occur. However if they try and update same record then which one is correct ?
What do you have in mind ?
Denis
•
•
Join Date: Jan 2007
Posts: 36
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
Update the same table (adding/editing) and updating different tables in the database. They can all access the database at the same time but can not update it. I know it can be a problem with editing the same table but is it a way where if they are all adding to the database it will update?
•
•
Join Date: Sep 2007
Location: Far reaches of known space
Posts: 58
Reputation:
Rep Power: 2
Solved Threads: 4
Junior Poster in Training
is this forms-based, that is, does each user update tables through forms? or does the user simply open a table?
is this a relational database? are the tables linked by foreign keys? or is this just a bunch of tables?
is this a relational database? are the tables linked by foreign keys? or is this just a bunch of tables?
(o) Yes, I'd like to reboot my computer now.
•
•
Join Date: Apr 2005
Location: Dundee, Scotland
Posts: 12,883
Reputation:
Rep Power: 32
Solved Threads: 305
In access 2003 you can change the recod locking options under TOOLS -> OPTIONS -> ADVANCED and you can choose:
Open Mode (shared or exclusive)
- Shared allows multiple users to run the database, exclusive doesnt.
"Default Record locking" has choices for:
No locks (BAD IDEA!!!)
All records (impractical)
Edited record (what you want)
chooosing edited record lets users use the database together but not work on the same record e.g a customer at once.
I have included a picture to show you:
Open Mode (shared or exclusive)
- Shared allows multiple users to run the database, exclusive doesnt.
"Default Record locking" has choices for:
No locks (BAD IDEA!!!)
All records (impractical)
Edited record (what you want)
chooosing edited record lets users use the database together but not work on the same record e.g a customer at once.
I have included a picture to show you:
Last edited by jbennet : Sep 25th, 2007 at 4:30 pm.
TRY MY SUGGESTIONS AT YOUR OWN RISK
Master of puppets Im pulling your strings, blinded by me, you cant see a thing. Master! Master!
Master of puppets Im pulling your strings, blinded by me, you cant see a thing. Master! Master!
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- I need help (Viruses, Spyware and other Nasties)
- clean up of temp files for multiple users (Windows NT / 2000 / XP / 2003)
- Homepage has been changed to about:blank (Viruses, Spyware and other Nasties)
- I can't remove about:blank (Viruses, Spyware and other Nasties)
- Another Trojan.Bookmarker.Gen (Viruses, Spyware and other Nasties)
- 35 processes, need to trim the fat (Viruses, Spyware and other Nasties)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: How to create Filemaker Pro "find mode" in Access 2003?
- Next Thread: How can I connect MS Access to SYBASE ASE db without repeatedly enter a user & passwd
