Desperate Help Needed

[Del]

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