There are two mdbs that may help you with this:
I'm not sure if they're included in the files in this group, but you
might be able to find them doing a google search. They're called
something like LogOutUsers.mdb and EnableUsersLogin.mdb.
Basically, there is a logout table where a flag gets set to true or
false. If you set the flag to true there is code attached to the
front end that gives the user so many seconds to log out, or else
the application.quit command occurs and their front-end closes,
thereby getting rid of the lock file. When you want the user to be
able to use the database again, you set the flag back to normal.
Jim
--- In AccessDevelopers@yahoogroups.com, [EMAIL PROTECTED] wrote:
> I usually just open the DSO window, switch to the drive and folder
and then
> issue the delete command from there. I've never had a problem
deleting
> files I don't own this way. The local user may have restricted
rights on
> the network security. Have someone with admin level rights try it.
>
> Hal McGee
> Engineering Data Manager
> Group Engineering - Process and Compliance
> Seating Products Group
> B/E Aerospace
> Winston-Salem, NC
>
>
>
> "stomper57"
>
<[EMAIL PROTECTED]
>
com> To
> Sent by:
AccessDevelopers@yahoogroups.com
>
AccessDevelopers@ cc
>
yahoogroups.com
>
Subject
> [AccessDevelopers] Re:
Delete .ldb
> 08/05/2005
11:47
>
AM
>
>
> Please respond
to
>
AccessDevelopers@
>
yahoogroups.com
>
>
>
>
>
>
> I tried walking my contact through this:
> G:\be>run command del /F MyDB.ldb
>
> I had to do this over the phone. I believe the user typed
> this correctly, but it didn't work. Is this the right
> command? Does this have to happen on the pc that owns the
> lock?
>
> This happens every couple of months and it is always the
> same user name that locks the database. The person is long
> gone and I've been having trouble knowing what pc this is
> tied to. At the site they have the multiple users using the
> same log in. Normally I have my contact run around to each
> pc and open/close the database. This usually works.
>
> After the lock is released, we are able to a compact and
> repair and clear the corrupt records. Then they are fine.
>
> Bryan
>
> --- In AccessDevelopers@yahoogroups.com, [EMAIL PROTECTED] wrote:
> > Sometimes I have had to open a DOS window and delete this file.
> >
> > Hal McGee
> > Engineering Data Manager
> > Group Engineering - Process and Compliance
> > Seating Products Group
> > B/E Aerospace
> > Winston-Salem, NC
> >
> >
> >
>
> > "stomper57"
>
> >
> <[EMAIL PROTECTED]
> >
> com> To
> > Sent by:
> AccessDevelopers@yahoogroups.com
> >
> AccessDevelopers@ cc
> >
> yahoogroups.com
> >
> Subject
> > [AccessDevelopers]
> Delete .ldb
> > 08/05/2005
> 10:58
> >
> AM
> >
>
> >
>
> > Please respond
> to
> >
> AccessDevelopers@
> >
> yahoogroups.com
> >
>
> >
>
> >
> >
> >
> >
> > Hi,
> > I have a split fe/be database that is locked up. It can't open
> > because of an unrecognized database format error. Everybody that
> > uses it is logged off. I had each user try opening and closing
> > the database to release the lock with no luck.
> >
> > I've tried to delete it directly and the .ldb doesn't delete.
> > What is the best way to remove the lock?
> >
> > Bryan
> >
> >
> >
> >
> >
> > Please zip all files prior to uploading to Files section.
> >
> >
> > YAHOO! GROUPS LINKS
> >
> > Visit your group "AccessDevelopers" on the web.
> >
> > To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> Service.
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
> YAHOO! GROUPS LINKS
>
> Visit your group "AccessDevelopers" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12h2cko35/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123268810/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
