andysgirl8800
Registered User.
- Local time
- Today, 16:20
- Joined
- Mar 28, 2005
- Messages
- 166
Hate to throw this issue back in the mix, but I seem to be really struggling to find a solution, even after extensive searching through posts. I can't seem to pin down any existing posts that directly addresses my problem, so here it is:
I have a DB that needs to be accessed by no fewer than 9 users for data entry and retrieval, no designing or programming. I seem to be running into a multiple user problem revolving around exclusive opening of some sort.
As it stands, about 4 users can open the DB simultaneously without issues. But as soon as a 5th person tries to open, they get an error saying they do not have exclusive rights, and the other 4 members run into problems closing their opened forms or tables with a "cannot save due to another user already has it open" and an error loop. Then, no one can close because of the auto save function in access.
I believe this may have something to do with workgroups, and have searched the forum with this keyword, but I'm not sure if this is where I need to go. I also don't know how to set it up from start to finish. Do I need to do something on each user's individual computer to make it work? And once I have one set up, will this absolve my current multi-user issues by specifying a shared access at all times?
Please help, as I'm getting a bit tangled up in the steps of this process. Is there a different solution? Thanks for any advice you can offer.
I have a DB that needs to be accessed by no fewer than 9 users for data entry and retrieval, no designing or programming. I seem to be running into a multiple user problem revolving around exclusive opening of some sort.
As it stands, about 4 users can open the DB simultaneously without issues. But as soon as a 5th person tries to open, they get an error saying they do not have exclusive rights, and the other 4 members run into problems closing their opened forms or tables with a "cannot save due to another user already has it open" and an error loop. Then, no one can close because of the auto save function in access.
I believe this may have something to do with workgroups, and have searched the forum with this keyword, but I'm not sure if this is where I need to go. I also don't know how to set it up from start to finish. Do I need to do something on each user's individual computer to make it work? And once I have one set up, will this absolve my current multi-user issues by specifying a shared access at all times?
Please help, as I'm getting a bit tangled up in the steps of this process. Is there a different solution? Thanks for any advice you can offer.