Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Make a table exclusive (2003)

    One of our departments has a very simple database consisting of several tables - no relationships. No forms. They do all their data entry directly in the individual tables (each table tracks correspondence for specific contract - there is a table for each contract). They swear that in the past, the tables were each individually locked so that multiple users can be in the database, but only one user at a time can enter records in the tables. And, now it doesn't work that way. How can I set the tables to be exclusive? There may be 50 people in the database at one time, but only one person is allowed in a table at a time. How can I do that?

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

    Re: Make a table exclusive (2003)

    You can have every user set Default Record Locking to All Records in the Advanced tab of Tools | Options...
    However, this is a user-level setting, so it will apply to all databases the user opens.
    Access does not have a setting for this at the individual table level, but it does at the query and form level.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make a table exclusive (2003)

    Ok. Thanks. That confirms what I thought.

Posting Permissions

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