[dba-Tech] Windows Explorer Find replacement

Arthur:

Couldn't you use the FileSearch object to get all the mdb files in an array, 
open them one by one and cycle through the table collection looking for the 
table name, or a field in the table?

Rocky

----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Discussion of Hardware and Software issues'" 
<dba-tech at databaseadvisors.com>
Sent: Monday, December 12, 2005 7:09 PM
Subject: Re: [dba-Tech] Windows Explorer Find replacement


>I just wish it would search Access files! I want to know which of 200 MDB
> files contains the table XYZ, and apparently I have no choice but to open
> each one. This ought not be difficult but apparently it is. Why, I do not
> know. Maybe there is a solution to this problem, ideally generic enough to
> also inspect MS-SQL MDF files too. And the MySQL databases too. I would 
> like
> to target all the databases of a certain type and locate a column XYZ 
> within
> them. That would be nice.
> I create a lot of documents to be sure, but that is not where the really
> important stuff lives. Yeah, I am a database geek, but so what, does that
> mean I am chopped liver?
> Incidentally, I almost never use PowerPoint but do the search things find
> text therein? And what about Excel files? And for that matter, what about
> text strings in executables?
> A.
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Josh McFarlane
> Sent: December 8, 2005 2:32 PM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] Windows Explorer Find replacement
>
> On 12/8/05, MartyConnelly <martyconnelly at shaw.ca> wrote:
>> I use Google's Desktop Search Engine. It takes about 12 hours to index a
>> full 20 gig drive.
>> Once done, searches are generally less than 5 seconds.
>> It only indexes to a depth of 5000 characters in a file unless
>> additional plugins used
>> You can search in only specific files by adding to the search string
>> filetype:doc to look at only word documents.
>> A plus is it also searchs your IE favourite URL's and whatever is in the
>> IE cache.
>>
>> I have used the find function only a couple of times in past year.
>
> I personally love it when I need to search text based documents.
>
> I have google search on my development machine, and it's pretty
> accurate when I need to dig up a 3rd-party header file or such that I
> remember downloading at one time, but forgot where I put it.
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>