Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple login problem (A2002 SP3)

    We have a slight problem with logins for our application, & I was wondering whether anyone had any ideas on this.

    Our applications are designed so that it should be possible for the same person to login to the same application more than once on the same PC. This is allowed.
    However, on one particular PC when the user logs in for the second time the message appears

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple login problem (A2002 SP3)

    What happens when the user logs in on another PC?
    What happens when another user logs in on the PC where the problem occurred?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    Hans

    No problem for users logging in on other PC's.
    On the problem PC when starting the application for the second time it does get as far as the login screen so it does not matter who the user is.

    Nick

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    Hans

    Sorry missed a crucial NOT on my previous post

    No problem for users logging in on other PC's.
    On the problem PC when starting the application for the second time it does NOT get as far as the login screen so it does not matter who the user is.

    Nick

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple login problem (A2002 SP3)

    Sorry, I wasn't clear enough. What I meant was:
    1) What happens if the person who has the problem logs into Windows on another PC (using his normal Windows username and password), then tries to open the database twice?
    2) What happens if another person logs into Windows on the problem PC (using his normal Windows username and password), then tries to open the database twice?

    What I'm trying to find out is whether the problem is bound to the PC or to the user.
    If it's user-related, check whether this user has modify permissions (read/write/create/delete) on the folder that contains the database. Without modify permissions on the folder, Access will not work correctly.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    Hans

    1. For other PC's there is no problem in logging in twice, only on the problem one.
    2. On the problem PC two users (me and the tester) have logged in with our network ID's and cannot log in to the app twice.

    Which makes me think the problem is on the PC not the application.

    Nick

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple login problem (A2002 SP3)

    Just to make sure: where is the database stored - on the network, or on the PC? If the latter, in the user's profile (for example in My Documents or a subfolder) or in a common folder?
    If the database is split into a frontend and backend, the above question applies to both.

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    Hans

    It's an MDE stored in C:Program FilesAppname

    It's a front-end which connects via ODBC to SQL Server (no linked tables)

    nick

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple login problem (A2002 SP3)

    Thanks. Check the default permissions for the folder C:Program FilesAppname. As noted above, all users should have Modify permissions in this folder.

  10. #10
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    (Edited by HansV to make URL clickable. It's very easy - see <!help=19>Help 19<!/help>)

    Just curious.

    Why would you want to have same user on same computer open same application more than once?

    When I first started installing access apps, my users were unintentionally opening multiple instances of same appl and eventually running out of resources, to coorect this I had to install the following

    John

    'Acess Web WinCheckMultipleInstances
    'http://www.mvps.org/access/api/api0041.htm
    ' ---Posted by Graham Mandeno---

    ' --------------------------------------------------------------------------------
    ' API: Preventing multiple instances of a database
    ' --------------------------------------------------------------------------------

  11. #11
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    Hans/John

    Sorry for the delay in replying.

    We finally managed to nail down the reason for the problem PC acting in the way it did. It was down to that PC having Adobe Acrobat 7 installed, and the Acrobat toolbar enabled in Access. As soon as Acrobat was uninstalled the problem went away. Why this should be so, I am unsure.

    As far as users logging in twice, our systems do not allow it. However, the checking is done after the login screen has been shown and the id/password entered. In this particular case it would not even reach the login screen, and that was the problem.

    Thanks for your hep

    Nick

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple login problem (A2002 SP3)

    I don't know the exact reason, but I do know that the Adobe toolbar causes weird problems in all Office applications, so it's a good idea to get rid of it.

  13. #13
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    When you "get rid of it", is it sufficient simply to uncheck it so it is not viewable, or do you mean it should be uninstalled? If the latter, how does one go about doing that without uninstalling Adobe Acrobat itself?

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple login problem (A2002 SP3)

    Just hiding the toolbar is not enough, you must uninstall the Acrobat add-in in Tools | Add-ins | Add-in Manager. This can be done without uninstalling the Acrobat application.

  15. #15
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple login problem (A2002 SP3)

    Thanks, Hans. I have some users that are getting the message "You do not have exclusive access to the database..." and while searching for solutions to the problem I came across this thread. I know one of the users has the Adobe toolbar as an Add-In to MS Access.
    If the Adobe toolbar is removed via the method you describe does that action remove from all MS Office app's?

Page 1 of 2 12 LastLast

Posting Permissions

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