Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclusive Isn't (Access 2000 SR 1)

    We have a couple of Access 2000 Databases set up on a server, and we're having the opposite Exclusive Use problem that most people seem to write about. Our problem is that Access DOES allow multiple people to access the databases simultaneously, and does NOT warn users someone else already has it open. Changes made by the second person to open overwrite changes made by the first person. If the first person changes a record, saves and exits, then the second person changes a different record, saves and exits, the changes made by the first person are overwritten.

    I've checked carefully -- the Tools > Options > Advanced > Default option mode is set to Exclusive. Access just seems to ignore it.

    Any thoughts? I don't particularly care whether multiple users can open simultaneously or not.... I just don't want to lose the changes made by the first user.

    Thanks

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive Isn't (Access 2000 SR 1)

    Do you have the common arrangement of a front-end, backend database? Or are you dealing with one stand alone database?

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive Isn't (Access 2000 SR 1)

    One stand-alone database with several tables.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Exclusive Isn't (Access 2000 SR 1)

    You say: " If the first person changes a record, saves and exits, then the second person changes a different record, saves and exits, the changes made by the first person are overwritten. "

    If they are different records what do you mean by overwritten?
    The usual iossue with mutliple use is changes to the Design of things, not changes to data. Multiple users are supposed to be able to change data at the same time, as tlong as they don't try to change the same piece of data at the same time.
    Regards
    John



  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Exclusive Isn't (Access 2000 SR 1)

    That is normal if you are using page, rather than record, locking. You can't keep people from changing records that someone else has edited unless you give them read only forms. If you're using page locking, a block of data, not a single record, is locked ny the edit. In databases, the last one who saves wins. If you get more specific about the way you wish it to work, maybe someone can help.
    Charlotte

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive Isn't (Access 2000 SR 1)

    John, thanks for your help.

    To clarify: We have one stand-alone database. The database has several tables. We're not using forms; people just enter data in the tables.

    Alpha opens the Letters table. She changes record #1. While she still has it open, Bravo opens the same table and changes record #2. Alpha changes record #3 and exits the Access (while Bravo still has it open) Bravo changes record #4, then exits Access. When the next person opens the table, Bravo's changes to records #2 and #3 appear, but Alpha's changes to record #4 are not shown. That record appears as it was when Bravo opened the table.

    What I want is the easier of:
    (A) multple people can open the database simultaneously, but the last change to a given record is the one saved, or
    ([img]/forums/images/smilies/cool.gif[/img] only one person can open a given table at a given time.

    Very much appreciate the help,

    Don

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Exclusive Isn't (Access 2000 SR 1)

    You can experiment with the locking options .. tools...Options..Advanced.

    Your second option is easily achieved -- setting default locking to all records will lock an entire table whenever it is open.. This might be too restrictive however.
    Setting it to edit record , combined with Record Level locking , would give more flexibility.

    You can experiment with this yourself, by opening two copies of the database at once on your own computer and move back and forth between the two seeing what it will let you do.
    Regards
    John



Posting Permissions

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