Jim Dettman
jimdettman at earthlink.net
Thu Jun 29 13:16:13 CDT 2006
Drew, <<Yes, but what value represents a 'suspect' user? In 97 it was 00 01 (or 01 00).>> Wish I knew<g>. I haven't dug around much the past four or five years as I've pretty much moved to VFP and nothing has even been documented for JET 4.0 that I'm aware of. Some of the database repair companies out there must have figured it out, but I don't think they'll give you an answer. Martin is probably closest to MSFT at the moment. He might be able to get you an answer. You also might ask Peter Miller at PK Solutions. He does offer repair services, but if you ask developer to developer, he might tell you how to check. He was pretty free with info when he was on the MS Access forum on CompuServe. He's the one that first spilled in public how to break user level security in Access. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, June 29, 2006 1:01 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] LDBView Yes, but what value represents a 'suspect' user? In 97 it was 00 01 (or 01 00). Drew -----Original Message----- From: Jim Dettman [mailto:jimdettman at earthlink.net] Sent: Thursday, June 29, 2006 11:51 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] LDBView Drew, The suspect flag is in the DBH (Database header page) along with the commit bytes, which has never been fully documented, but just mentioned in passing. It's that along with the locks that determine what state a process was in at the point of disconnect. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, June 29, 2006 11:52 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] LDBView Not really the issue, I know how to read the .ldb, even where to look in the .mdb as far as what .ldb users are actually active. Have to determine the 'suspect' flag though. Drew -----Original Message----- From: David A. Gibson [mailto:dgibso at uark.edu] Sent: Thursday, June 29, 2006 10:35 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] LDBView I can use EditPad Lite to open ldb files and see the computer name. That may be a little help. EditPad Lite if the free version and there is a Pro ver. You can replace Notepad as the default text editor. :-) http://www.editpadpro.com/ David G. At 09:24 AM 6/29/2006, you wrote: >Does anyone have something like LDBView for 2000 (or newer) databases? We >recently converted from Office 97 to Office 2003, and have a few of our >databases (even very stable ones) get corrupted several times in the last >week and a half. LDBView would tell me who corrupted a 97 database, but it >doesn't work correctly with Access 2000 and up. Everything I have found on >Google so far points to an MSKB article which has code to get a schema >through ADO, to see who is in a database. That's all well and good, but it >doesn't work if the db is corrupt, because it can't connect to it. I even >created an app that stayed 'in' the database, and when it went corrupt, the >code from MS didn't show who corrupted it. > > > >I am about halfway through creating a new LDBView, but it's involving a lot >of guess work and reverse engineering. Getting a little tired of walking up >hill with this, so if anyone has something prebuilt, it would be much >appreciated! > > > >Drew -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com