Results 1 to 5 of 5
  1. #1
    DianeG is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    16

    Remote Desktop Database Needs Help

    I have a database on a remote desktop so numerous people can use it at the same time. For some reason if two people try to select from the same drop down in a form at the same time one of them will get locked out and have to wait quite awhile. Does anyone have an idea of how to make this work better?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you're sure that it's happening at the exact same time?? that's pretty unique, even with a lot of users.

    do you have record locks on? It doesn't sound like it, if they're both in the same form at the same time. If you do though, what's the setting on it?? You can find it on the form property sheet.

  3. #3
    DianeG is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    16

    Reply to ajetrumpet

    It is set for No Locks. The problem shows up when we are doing a training on the use of the database so there are a number of people trying to do the same thing at the same time. I don't think this would happen in a normal situation, but I was asked to find out if there is a way to fix this.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    this might help: http://www.google.com/#sclient=psy&h...7&pf=p&pdl=300

    also, one thread I saw posted this update as a solution that fixed their issue with locking out on a remote machine: http://support.microsoft.com/kb/969084

    other than that, I'm not sure. I've only used Excel 97 through the remote desktop connection in windows (and that was many years ago), so my experience with this is nill.

  5. #5
    DianeG is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    16
    Thanks for the quick replies I will check out the links you sent. Thanks for the help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can you run just a form from the desktop?
    By Felix_too in forum Forms
    Replies: 2
    Last Post: 12-29-2010, 06:50 PM
  2. Access and Remote Desktop
    By pedsys in forum Access
    Replies: 1
    Last Post: 10-08-2010, 10:42 AM
  3. Remote Access
    By treva26 in forum Access
    Replies: 1
    Last Post: 09-03-2009, 06:56 AM
  4. Remote database access
    By marleyuk in forum Programming
    Replies: 0
    Last Post: 01-15-2009, 01:43 PM
  5. How to Use Remote DB
    By saravanan.baskaran in forum Access
    Replies: 0
    Last Post: 01-10-2009, 03:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums