[AccessD] Find MDBs

Yes you do, and that's what the code I have does.  In my case, I had several DBs all belonging to the same Access Workgroup, so it was easy to use the same code to open them, check, and set the property.  Might be more of a challenge if you have DBs using a variety of WGs - don't know, as I'm not too savvy about that.  Shamil's post describes the method well - open the DB, look for the property, check its value, reset if necessary, close the DB.

-----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 10:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com