Jim Dettman
jimdettman at verizon.net
Thu Sep 27 06:31:34 CDT 2012
Rocky, Reading the .LDB file directly won't get you anywhere as there is a corresponding user lock that determines if a user is actually in the DB or not. Also if your not using ULS security, all you will get is the station name (every user will be "admin"). The old LDB Viewer from Microsoft looks at the user locks, but only works with JET DB's and not the new ACE format (2007 and up). Best LDB utility I've found to date is one written by Frank Hilton and I believe it works with the ACE format. You can download it from EE here: http://rdsrc.us/HLR1d1 It's written in VB. Look for it in the second comment from the bottom along with the screen shot. Note that it uses either the MSLDBUSR.DLL or the ADO Jet roster schema to fetch the basic data (which is what you can use as well in code if you want to build your own utility). Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Wednesday, September 26, 2012 07:36 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Read an ldb File Dear List: I'm about to re-invent the wheel by making an app that will read an ldb file. (Have a client that I can't update the back end because someone's logged in and he can't find out who.) Started by cribbing a module of a MS support site. But them it occurred to me that there might already be something on a site somewhere to do this. Does anyone know of such a program I could download? MTIA Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com