[AccessD] Find MDBs

Don,

That would be nice.  I thought you had to open the DB to detect/change that property?

Thanks,

Mark A. Matte


> From: Donald.A.McGillivray at sprint.com
> To: accessd at databaseadvisors.com
> Date: Tue, 1 Apr 2008 11:56:34 -0500
> Subject: Re: [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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
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