Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    38

    Unanswered: Database only allows 1 user

    hi guys,

    before you say look, i have!

    not really had an issue over this for a while as database which is on a server was only mainly used by 1 person, is now needed to be accessed by 3 or 4.

    used to be able to have mulit users, then they wanted it password protected, this stopped the multi user functionality, I have removed the password, but still it only logs in as admin user and stops anyone else logging in to it.

    I am only a basic user and dont often delve into this. I have checked the settings and it is supposed to open as a shared file

    any help would be appreciated.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Is this a split app with a copy of the front end on each user's PC and the back end on the server?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Check the code bank on this:

    http://www.dbforums.com/6274786-post19.html (multiple users in an mdb file)

    and

    http://www.dbforums.com/6332819-post68.html (find out who's logging in and permission example)

    There are more examples in the code bank.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2007
    Posts
    38
    Quote Originally Posted by Missinglinq View Post
    Is this a split app with a copy of the front end on each user's PC and the back end on the server?
    no, its not split, just the one copy

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Then split the db. You'll have a much easier time working on the front-end and copying new code without having to worry about moving data between mdbs fiels. Again, see the links above.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    also check to see if someone is opening the copy with exclusive mode on
    check that none of the code modifies any objects
    deploy and individual copy of the front end so any problems in that front end are local to that user.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •