[AccessD] Find MDBs

jwcolby jwcolby at colbyconsulting.com
Tue Apr 1 11:54:06 CDT 2008


Sounds like a pretty handy widget.  If you aren't planning on selling it,
how about putting it up on the downloads page of DatabaseAdvisors.com? 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----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 12:41 PM
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




More information about the AccessD mailing list