Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sharing a database (Access 2000)

    I have a client inquiring about the best way to have Access set up so they can both be working in the database at the same time and have their work saved without conflicts. The database sits in a shared network folder and when they both have the same table open and try to save changes to records, a message appears asking whose changes will be saved. Would it be best to set up some kind of security to lock individual records or would you set user permissions? Whatever the recommendation is I will require information about how to set up the security.

    Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sharing a database (Access 2000)

    Chona

    The best way is to split your database and then place a copy of the front-end on each of their PC's.
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Sharing a database (Access 2000)

    In addition to Don's comment, you want to make sure that record locking is selected as the locking mechanism. In addition, you want to set the locking strategy to No Locks, which doesn't really mean what it says exactly. No Locks means that no lock is applied until someone tries to save a record - then the record is locked until it has been saved. If you choose Edited Record, as soon as a user starts to edit a record, the record (or page if you are using page locking) is locked. When two people try to edit the same record, you will still get the error message, but that's when you want it! Hope this helps a bit.
    Wendell

Posting Permissions

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