Hi Bryan, Something that sticks out to me is that you have several people logging in with the same user account. This is a security nightmare. I do not know exactly how Access handles the login with the .ldb file. If it uses user id then that could cause a problem. If it uses IP or MAC addressing then there should be no problem. You also said that there was one user that seem to lock it down. I would be very suspect of that user and the version and table linkage. Do a search and make sure that you only have one .ldb out there. If you are using fe/be then the .ldb file should be only on the user's pc and not on the server. I keep a copy of the front end on the server for users to download to their pc if they have problems or if there is an upgrade. If you have an .ldb on your server then you have a problem there and it sounds like a user is maybe using a front end on the server. Is that possible in your situation? Maybe someone else can shed some more light on this. Bottom line, you should not have to worry about deleting the .ldb file, but I guess you already figured that one out.
Be sure to let us know your final solution. Glenn P. Jones -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of stomper57 Sent: Monday, 08 August, 2005 8:51 AM To: [email protected] Subject: [AccessDevelopers] Re: Delete .ldb Thanks. Right now I'd try just about anything. I'm still waiting on the system admin to kill the lock. Bryan --- In [email protected], "A.D.Tejpal" <[EMAIL PROTECTED]> wrote: > Bryan, > > If everything else fails and the ldb file proves too stubborn, following course of action could be tried so as to delete the file without resorting to re-booting of computer. > > Press Ctrl + Alt + Del so as to invoke the Task Manager. In the Processes tab, select msaccess.exe and click End. It should now be possible to delete the ldb file. > > With best wishes, > A.D.Tejpal > -------------- > > ----- Original Message ----- > From: stomper57 > To: [email protected] > Sent: Friday, August 05, 2005 20:28 > Subject: [AccessDevelopers] Delete .ldb > > > 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hgrsfhe/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123616390/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/
