[AccessD] Find MDBs

Mark,

Re the AllowBypassKey thing: I'm pretty sure you can detect that, set the value to True, do your thing, and then reset to False.  I have some cribbed code around here somewhere that I used for setting and clearing that attribute in various apps remotely.  Might be able to dig it up if you can't find it anywhere else . . .

HTH

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Tuesday, April 01, 2008 9:41 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Find MDBs



Hello All,

I just about have all of the functionality I can think of sorted out...thanks to Jack and Shamil.

I have had a few projects where I was was asked to 'figure out' what all of the mdb's on their network were.

So far with the new approach here is what the this database does:

1.  Gets all MDB's in selected folder/Drive( including subfolders )
2.  Gets all object names in each MDB.
3.  Gets MDB CreationDT,LastUpdate,Size,and Version of Access.
4.  Allows searching of ALL modules in each MDB for key words("MySearchText")


Obstacles:
1.  Databases that have AllowBypassKey=False...The mdb opens and starts doing whatever it is supposed to.  I can still get the info...but would be nice if I could detect these and get info a different way.

2.  Database Passwords...(not worried about user security right now).  I have a tool "accesspv.exe"...that will give the password...but I'm not sure how to automate with this tool.  I can launch it with a command line...the answer pops up...but not sure how to get the answer back into my code.  I'm open to products/solutions.

3.  Does not look in 'zipped/compressed' folders.  Not sure how to look at these?


Just curious if anyone has any other attributes they think would be handy in this type of tool...or suggestions of any type.

Thanks again,

Mark A. Matte



_________________________________________________________________
More immediate than e-mail? Get instant access with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com