who is online on mdb file

[Guest]

I currently have a Database and several users are able to use this File. I`m
currently updating few parts of the Database. I usually go in the database
and lock the file so other user are not able to logon while i`m updating.
Since few days I have users still connected to the database and this doesn't
allow be to do my update. Is the a way ( forms, modules ) that can tell me
who is currently log into the database ? also is there a command that can
KICK the user out of the program ??

 

[Ron2006]

As to the first question:

Try this link: http://www.mvps.org/access/modules/mdl0055.htm

it has a small access app that looks at the ldb file and will tell you
all of the users that are logged into mdb that you reference.


really neat and small, and the code for the form can be imported into
any app that you want or run standalone out of this app. With that you
may be able to tell what machine is actually holding open the ldb file
without having to try to guess.

=================
As to the second part.

Do you have the database split between data and application AND the
application on each of the users hard drive. This is the preferable way
to operate AND this would allow you to make changes to the application
at any time.

Here are two references about splitting the application.

Split your MDB file into data and application
http://allenbrowne.com/ser-01.html

Splitting your Microsoft Access MDB into a front end and back end
http://www.granite.ab.ca/access/splitapp/index.htm

=======================

Ron