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?
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.
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
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.
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.