[AccessD] LDBView

The 'suspect' column.  Only works for a 97 mdb though.  In 2000 and up, the
suspect column is 'yes' for everyone not in the database.

Drew

-----Original Message-----
From: Jim Hewson [mailto:JHewson at karta.com] 
Sent: Thursday, June 29, 2006 9:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] LDBView

How does it tell you who corrupted a database?
I use the 1997 version to see who is in all versions ('97, 2000, XP, 2003).
But, I didn't know it would tell you who corrupted a database.

Jim 
jhewson at karta.com
 

-----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 9:25 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] LDBView

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