INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access not allowing user in when multiple users in same database.

Access not allowing user in when multiple users in same database.

Access not allowing user in when multiple users in same database.

(OP)
I have a database that has worked without flaw with multiple users accessing the database for years. Recently a new user was added; the user has been given all security levels with access but when she tries to access the database when others are in it, she is locked out. However if she accesses prior to anyone else, then she has no problem and others have no problem either.
It definitely has something to do with her user credentials with access. We have reloaded the program, but no change. The data is stored on a server; each user has access loaded on their PC. Any ideas will be appreciated.

RE: Access not allowing user in when multiple users in same database.

Can the new user create and delete files in the folder containing the Access file?

Duane
Hook'D on Access
MS Access MVP

RE: Access not allowing user in when multiple users in same database.

(OP)
yes, there are multiple data bases in the access folder (drive s). user can open all other access data bases except this one. All security settings and permissions are the same.

RE: Access not allowing user in when multiple users in same database.

Is this Database split into a front end/back end configuration, with each user having a copy of the front end (with everything except Tables in it) and the back end (with Tables) on a shared drive?

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

RE: Access not allowing user in when multiple users in same database.

(OP)
No, it is not split front/back end configuration. I have never had a problem with it before until they upgraded the server. I have found that if the access program itself is opened first, then the DB can be opened. It doesnt work if using the desk top shortcut is used. But on other PC's it does. I have checked the security settings and there is nothing different on either machines.

RE: Access not allowing user in when multiple users in same database.

Not splitting the FE/BE is asking for trouble with a multi-user environment. When a user opens the Access database it creates a lock file, which may not normally be an issue, but when a second user opens the Access database, it sees that there a lock file (but 'created' by the first user). Thus if the first user exits Access before the second user, Windows and Access can get confused. FYI: If you are on a Novell network it can be worse. Our team was able to split an Access database that was being used by 20 users (after many restores from backup because the DB got corrupted). No problems now (back end is now MS-SQL).

RE: Access not allowing user in when multiple users in same database.

Having multiple users sharing a single, non-split database, sitting on a network drive, is the sure way to repeated episodes of corruption, speed and timing issues (timing coming to mind from your description) as well as all manner of odd things happening! Multiple users simply have to work off of a split database, with each user having their own copy of the Front End, which contains everything except the data/tables, on their respective hard drives, and a Back End with only the Tables on a shared drive.

Being in forced retirement, I spend 8-10 hours a day here and on other Access forums/newsgroups, and over the past ten years have seen dozens and dozens of reports of non-split apps causing all kind of problems! The really insidious thing is that a non-split app can work for extended periods of time before the troubles begin! But once it does, they become chronic, which is to say they occur over and over and over again! http://www.tek-tips.com/viewthread.cfm?qid=1767514


Linq ;0)>

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close