Erwin Craps - IT Helps
Erwin.Craps at ithelps.eu
Thu Apr 10 01:19:29 CDT 2008
If you have a windows server you can see who is keeping which files open on the server. In computer Management>Shared Folders>open files. It's the network user name that show there (not the Access user). This open files also works if the server is a regular windows pc, but I'm not sure what you will see if you don't have a domain. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Thursday, April 10, 2008 6:26 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Reading an .ldb File And http://support.microsoft.com/kb/198755/EN-US/ On 10 Apr 2008 at 12:29, Darren D wrote: > Check out > > http://support.microsoft.com/kb/186304 > > haven't tested it though > > Darren > ----------------- > T: 1300 301 731 > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters > Sent: Thursday, 10 April 2008 4:48 AM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Reading an .ldb File > > Just for FYI: > > This morning I was working with a customer where someone had opened a > database which we needed to close, but we didn't have way of finding out who > had opened it. Out of frustration, I made a copy of the .ldb file, changed > the .ldb to .txt, and opened the file. Lo and Behold - the user names and > computer names of the logged in users were displayed. > > Interestingly, it appears that the first person who logs in has their user > displayed as Admin, not their actual user name. But because the computer > name was correct, we were able to figure out who it was and get him to close > his instance of Access. > > The computer names and user names are all in the first row of text, so you > may want to hit the Enter key a few times for better readability. > > Perhaps this would be useful...! > Dan > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com