Making Access multiuser

[dolodolo]

Hi,

How can I make my Access DB multiuser?

Thanks,
Dolores

 

[smedvid]

I thought... MS Access is Multi-User in nature by default with table/record locking.

Depending upon your specific needs, such as security (MDW) and types of data, etc... you could employ VBA customizations, if needed.

htwh,


Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[dolodolo]

Hi,

Thanks for your reply. We are not using user level security - it's a nightmare. When the DB is open, no one else can open it. You click on it and nothing happens.

I am having the folder containing the DB shared specifically. I'll see how that works.

Again thanks for your prompt reply.

Dolores

 

[Vyurr]

Have you used the Database Splitter to split the database? If not, that's probably your answer. Each user can then have a front end on their own machine and you can store the backend (data part) in the shared drive.

 

[smedvid]

Agreed - that is best!
Split that database... Data and Front-End Stuff...

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[jrbarnett]

dolodolo - is your database set to open exclusive?

John

 

[dhookom]

This sounds like it might be an issue similar to thread181-1545476.

Duane
Hook'D on Access
MS Access MVP

 

[dolodolo]

Thanks All,

It turns out that it will open once Access is open but not from Explorer - strange quirk.

Again thanks all for your help!

Dolores