Search all mdb files for query names

[willybgw]

I would like to have a database of all queries in all databases with the database path, query name, and last change date. The thread below is what I am trying to accomplish I think. I have created a table with all (491) database paths, but I don't know what to do from there.

As always all help is appreciated.

thread181-1572741

willybgw

 

[lameid]

In Access help lookup OpenCurrentDatabase Method

Once you open the database, you can loop through any of the objects collecions...

I generally set another access instance's visible property to false.

Hopefully that is the nudge in the right direction to get you going.

 

[willybgw]

Lameid - Thanks for the response. I am out of town until Monday and will check out your suggestions then.

willybgw

 

[willybgw]

Could someone please explain what should go after the IN. This is from dhookom's post in linked thread.


SELECT *
FROM MsysObjects
IN 'YourMDBFileNameWithPathHere';

folder: C:\MY DOCUMENTS
database name is: FIND_MDB_OBJECT.MDB
table name is: MDBLIST
field name with path is: MDB_PATH

Thanks,
willybgw

 

[lameid]

I doubt this integrates into what you are doing directly but this is an example using the folder and database you listed....

SELECT * 
FROM MsysObjects IN 'C:\My Documents\FIND_MDB_OBJECT.MDB'

 

[willybgw]

lameid - thanks again for the help. This works to get the query information from FIND_MDB_OBJECT.MDB. The problem with that is I want the query information from the 491 records in table MDBLIST.

willybgw