Results 1 to 2 of 2
  1. #1
    David is offline Novice
    Windows 2K Access 2000
    Join Date
    Jul 2009
    Posts
    1

    Access Locking other users out


    We have numerious databases we use and have found that there are some computers that when they open a database up and without accessing anything in it will lock out everone else but if other users open the data base up they dont lock eveyone else out.

    We run a variety of operating systems on our comps but there is no consistancy when you look at the comps concerned.

    The version database is 2000

    If a user that dose not lock the database up opens it first then the user that locks it up other users can then also open it up.

    I would apprecite any help with this Thanks in advance.

    David.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    It is possible to open a db in *exclusive* mode rather than shared mode. It is a system property so it remains with Access rather than following a particular mdb. In acXP it is located in Tools>Options...>Advanced tab on the right.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Limiting access to certain users only
    By huskies in forum Security
    Replies: 1
    Last Post: 04-01-2009, 08:18 AM
  2. Users on Database Simultaneously
    By rtemple in forum Access
    Replies: 2
    Last Post: 03-26-2009, 08:38 PM
  3. Why 2 users cant open an access file directly???
    By finnegan bell in forum Access
    Replies: 6
    Last Post: 03-22-2009, 09:06 PM
  4. Track users use of Access database
    By booyeeka in forum Programming
    Replies: 1
    Last Post: 02-26-2009, 02:35 AM
  5. Replies: 0
    Last Post: 01-19-2007, 07:58 AM

Posting Permissions

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