Find a query or table in a bunch of mdb files

[luckless pedestrian]

I have a directory containing probably hundreds of mdb files. I need a
tool that will let me catalog the database objects in all the files and
let me search that catalog to find the file containing the query that I
need. I know something like this must exist, but I can not find it
anywhere.

Anyone have any ideas?

Thanks.

 

[Guest]

Hi Luckless,

You'll be happy to hear that you are not as luckless as you might think!
Althought it's a rather large download (51.2 MB), you can download and run
the Access 2003 Conversion Toolkit:

http://www.microsoft.com/downloads/...76-5D89-450A-B977-980A9841111E&displaylang=en

The actual database is about 11.2 MB; the rest of the download is tutorial
files with video and sound.

To use this tool for your needs:

1.) Click on Scan for Databases
2.) Select the Path or UNC share
3.) Make sure to enable the "DAO Properties" checkbox
4.) Complete the scanning operation
5.) Create a new query without adding any tables
Switch to SQL view by clicking on View > SQL View
Paste the following SQL statement in, replacing
the default SQL keyword SELECT:

SELECT tblQueries.QueryName, tblDatabases.DatabaseName,
tblDatabases.Path
FROM tblDatabases
INNER JOIN tblQueries
ON tblDatabases.DatabaseID = tblQueries.DatabaseID
ORDER BY tblQueries.QueryName;


Note: You may want to filter out temporary queries, which normally are not
displayed in the graphical user interface, by adding the indicated WHERE
clause:

SELECT tblQueries.QueryName, tblDatabases.DatabaseName,
tblDatabases.Path
FROM tblDatabases
INNER JOIN tblQueries
ON tblDatabases.DatabaseID = tblQueries.DatabaseID
WHERE Left$(tblQueries.QueryName, 1) <> "~"
ORDER BY tblQueries.QueryName;


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________