[AccessD] Find MDBs

Hi Mark,

AllowBypassKey is a database property - I think you can handle its value
using DAO, IOW open database using DAO and then check is there
AllowBypassKey property defined or not - if it's defined and its value is
True then you can change it temporarily to False... 

OpenCurrentDatabase starting MS Access 2003 has bstrPassword parameter:

Sub OpenCurrentDatabase(filepath As String, [Exclusive As Boolean = False],
[bstrPassword As String])

To block running AutoExec or Startup form execute 

SendKeys "+" 

before calling .OpenCurrentDataBase...

I hope the "tricks" listed above should help you to solve most of the issues
you mentioned in your post...

--
Shamil
 
-----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 8: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