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?

Re: Multiple Users Updating Simultaneously 80 80

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

Re: Multiple Users Updating Simultaneously 80 80

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?

Re: Multiple Users Updating Simultaneously 80 80

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?

Re: Multiple Users Updating Simultaneously 80 80

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:

Re: Multiple Users Updating Simultaneously 80 80

Thanks That Worked For Me.

Re: Multiple Users Updating Simultaneously 80 80

I still did not get it. If someone asks whether simultaneous updation causes any error or not, what will be my answer? Yes or No

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.