Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2009
    Posts
    6

    Question Unanswered: One user locks another user in.

    I just finished implementing a database (Access 97) and it seems to work ok except that when a 2nd user is in the database the 1st user can't close the form.
    Message:
    Couldn't save; currently locked by user 'Admin' on machine 'XXXXX'
    Ok or help buttons. When I press Ok

    Message:
    The save operation failed.
    Ok button

    Message:
    Out of Memory
    Ok or help buttons. When I press Ok
    Gets me back into the original form

    Is there anything I can do for multiple users or am I stuck with users asking other users to close the form?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    1) Be sure that the database is open in shared mode. I can't remember where the option is located in Access 97, in Access 2003 it's in the Tools Menu --> Options --> Advanced.

    2) If it's not already done put all the tables in an mdb file, say Data.mdb, and nothing else: this is the back end, then create linked tables to Data.mdb in another file, say Application.mdb, that will contain everything else (queries, forms, reports, macros, modules): this is the front end. Each user must have a copy of the front end while the back end is shared among all users.

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I've had a million "out of memory" issues with Access 97. All of which were solved by upgrading to Access 2003.

    Make sure you have all the service packs installed.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jul 2009
    Posts
    6
    Yes. The database is in share mode and default record locking is at "No locks".

    I'd love to use Access 2003 (I actually started the dbase in 2003 and had to re-do it in 97) The rest of the users only have 97 and can not have the company buy 2003. It won't work for them if I make it in 2003

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well then it's going to come down to what the form is doing to see why the record is locked at the time it is being closed. If the second user is putting data into the edit state and then the first user attempts to save data, then commands are going to fail, but it's the "out of memory" thing that's the oddity here.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Jul 2009
    Posts
    6
    Yeah that is an odd message to be out of memory (May be Alzhaimers). I actually saw the same thing in an other dbase a long time ago and never investigated. Now I wish I had.
    Guess I can live with the situation. Thanks.

Posting Permissions

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