Desperate Help Needed

[Guest]

We are running Windows XP on a 5 user network.
When ever anyone uses Access (Access 97 SR-2) anybody else who also tries to
use it at the same time gets the following message when they try to log out.
"Couldn't save, currently locked by user Admin on machine 'clinonxp'.
When you press OK then the following message "the saved operation failed"
then when you press ok to that you get the message "Out of Memory"
Anyone who can help solve this will have my lifelong gratitude.
Thanks Del

 

[Albert D.Kallal]

A few things:

First, ALL users on the network must have full rights to the shared folder.
(this means file create rights, and file delete rights also).

The next thing you need to do is split your database. That means that EACH
workstation gets a copy of the application installed ON EACH computer.

And, further, you likely should distribute a mde to each user, not a mdb.

And, last but not least, you also want to ensure that all machines are
running the same version of JET, that means you need to install the
jetsp35.exe on each work station also.

You can read up on splitting here:

Further, since you are running xp, then you may have to keep a persistent
connection open to make the application perform at the same speed as before.

 

[Albert D.Kallal]

oops, forget the link, here it is:
You can read up on splitting here:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

 

[Joseph Meehan]

We are running Windows XP on a 5 user network.
When ever anyone uses Access (Access 97 SR-2) anybody else who also
tries to use it at the same time gets the following message when they
try to log out. "Couldn't save, currently locked by user Admin on
machine 'clinonxp'.
When you press OK then the following message "the saved operation
failed" then when you press ok to that you get the message "Out of
Memory"
Anyone who can help solve this will have my lifelong gratitude.
Thanks Del

Assuming that is XP home, the network may not up up to Access. Access
needs a very good network to be reliable.

In any case, you may try making sure no one has Access open and then
check to see if there is a YOURFILENAME.LDB file in the same directory as
the Access file. If there is delete it. Also make sure that all users have
full access (create, edit, delete, read) rights to the directory where the
file is located. If you have not already done so, split the database into a
back end accessed by each user via there own copy of the front end. The
back end contains only data tables and all the other stuff is in the front
end Access files located on each user's own computer which are linked to the
back end.