I have developed a multi-user application (MDB).
At times when I need to do maintenance, I want
to find out who are currently loggon (users).

Is there a "built-in" way of finding out who are
currently using an "MDB"/database file?

Is there a way of "kicking" users who are currently
using an "MDB"/database file; selectively or "all"?


Thanks,
Fred

You don't mention the version, but for 97 you can use ldbview.exe. It is
part of the jetutils download. See ACC: Microsoft Jet Utilities Available
in Download Center
http://support.microsoft.com/default...b;en-us;176670

If 2000/2002 see
HOW TO: Check Who Logged into Database with Jet UserRoster in Access 2000
http://support.microsoft.com/default...b;en-us;198755

Also Total Access Admin from FMS will give you this
http://www.fmsinc.com/products/Admin/index.asp

To kick users out, there is a sample at
http://www.datastrat.com/Download2.html
called KickEmOff2K; also the Total Access Admin tool allows you to do this.

--
Joan Wild
Microsoft Access MVP


"fred" <(E-Mail Removed)> wrote in message
news:091b01c361f3$b6e69da0$(E-Mail Removed)...
> I have developed a multi-user application (MDB).
> At times when I need to do maintenance, I want
> to find out who are currently loggon (users).
>
> Is there a "built-in" way of finding out who are
> currently using an "MDB"/database file?
>
> Is there a way of "kicking" users who are currently
> using an "MDB"/database file; selectively or "all"?
>
>
> Thanks,
> Fred