Michelle said:
Is there anyway to break the connection between a user and
a front end? Someone has an instance of my application
open (I see MDC.ldb Access.LockFile in the file folder)
and I want to force it to close anyway.
You can also view the contents of the .ldb file to see who it is.
Open the .ldb file will show you both who's currently in the database
and some of the workstations which were in the database. When a
person exits Access their workstation name and Access login id, Admin
unless you are using Access security, are left in a "slot" or record
in the ldb file. This slot or record may get overwritten the next
time someone enters the MDB depending on what slot or record is
available previous to it in the ldb file.
In Jet 3.5/Access 97 you need to use LDBView. See ACC: Microsoft Jet
Utilities Available in Download Center Q176670
LDBView will not work for Jet 4.0/Access 2000/2002 MDBs as it always
flags the suspect column as yes whenever everyone exits the MDB. For
Jet 4.0/Access 2000/2002 See HOW TO: Check Who Logged into Database
with Jet UserRoster in Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;198755
or
http://support.microsoft.com/default.aspx?scid=kb;en-us;285822
Also see LDB Viewer Form which has the above code in a form in an MDB
for you.
http://www.mvps.org/access/modules/mdl0055.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm