I have implemented ForceUserOut from [EMAIL PROTECTED] I tied it to the main table in the database and I still get the unrecognised database format. This sometimes works in releasing the lock.
Bryan --- In [email protected], "jmw95823" <[EMAIL PROTECTED]> wrote: > 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 [email protected], [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: > [email protected] > > > 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 [email protected], [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: > > [email protected] > > > > > 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=12h13atsn/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123269914/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</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/
