Split the database. Every user should get their own copy of the FE on
their workstation. Only the tables belong in the shared BE. See
http://www.granite.ab.ca/access/splitapp/index.htm

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

is not split.

You might want the network people to read the following article about
splitting:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

It is possible that the network people DO NOT understand the difference
between a file, and a application (on the other hand, I can't imagine people
managing computers and not being  able to tell the difference between a file
and a application).

You, and you network people need to sit down and read the above article, as
it is important for them to understand the difference between files, and
that of software applications that run on a computer.  Have them read the
above...

Hi Pamela,

I am not an expert like the wonderful guys who usually reply but i have also
had a similar problem which i sorted myself after getting similar 'split the
database' answers (which i cannot do).

I created a table called close in which i can add a value which is a time
and date. I then created a little form which has the current date and the
date from the 'close' form and then set a timer to refresh the values every
ten seconds, then if the current time passes the 'close' time the database
closes, using the "quit" command.

So points to note however, i had to do something that says after a minute
after the 'close' time, clear the cell on the form otherwise everytime you
reopen the database it closes because the time has passed.

You have to make sure that the form always opens for each user (i used
autoexec) and they cannot close it, i took away the [x] and won't let them
view the design.

It seems to work very well, even if there are 'ghost' users etc, i even
added to it so it works automatically at 7pm each night. I'll warn you it
took me a while to get everything refreshing correctly and i 'fudged'
somewhat as i couldn't get one bit to refresh, so i just applied a sort or a
filter on the one single record in the 'close' table which seemed to get it
to recognise/refresh the value.

Hope this helps.
Emma