Lavsa, Rich
Rich_Lavsa at pghcorning.com
Mon Oct 4 12:53:17 CDT 2004
Well I walked over to the network administrator and ask if he could reboot the server for me, as I remembered reading somewhere some time ago (can't remember where) that sometimes you may need to reboot the machine to delete the LDB file. In doing so, he opened his Active Directory User Interface and went to the server in question. He looked to see who was logged in, then he went into Sessions, there he could see every file that everyone is using. At the top of the list were all my users (including the one with 5 sessions running against the same LDB and MDW file). I ask him if he could manually close these files and said only if I know they weren't using them. I knew everyone was out of the system because of the problem so we did it. I ask a user to log in and out to give the database a chance to clean up its own LDB files and sure enough it did. And the speed is back to what it should be. I don't know if I stumbled upon anything in looking at the sessions of a server but it might be worth noting for anyone out there that has an issue with Orphaned users in LDB file. Thanks for all who responded, Rich -----Original Message----- From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com] Sent: Monday, October 04, 2004 11:22 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] LDB File, Orphaned Logins Hello all, I have a database that has been working for almost 2 years now with no trouble. It is split, with security. Both BE and FE share same MDW file. There have been no changes to this database for about a year. Recently the users are complaining about it becoming slow. I looked into some things, compressed and repair FE and BE. Still no luck. I noticed that even though everyone was out of the database that there were still LDB files (1 for BE and 1 for MDW) left on the server. I opened them in notepad and saw about 8 users still logged in, 5 of which were the same person. I tried to delete the LDB files, of which I got an error "cannot delete file due to a sharing violation". I have never had a corrupt database or LDB file, I'm hoping this isn't my first as this is a fairly large and complex database. Any help on how to clear these users out of the LDB File would be greatly appreciated. Thanks, Rich -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com