Question Windows search to find a certain database among my files

[PaulWilson]

I can use windows search to find a Microsoft Word document or a Microsoft Excel spreadsheet or a PowerPoint presentation using the built in search function that comes with Windows. I can search file contents using keywords and if I index the directory, it's pretty quick.

I remember a sample database I made a year ago that has a special structure to it and I remember the names of a few controls and tables in that database. Among the many example databases I have I can't remember it's name. I know it's there, but I can't find it! Windows search seems to exclude Access from it's searchable scope.

Does anyone know of any third party utilities that I can use to search through my collection of Access databases?
Alternatively, does anyone know how to get Windows to search through Access files? After all, it is their product!

 

[Guus2005]

you can search for files with a certain extension or even into tekst files for a certain string in the tekst.

Use V-Tools, Ricks Find and Replace tool or use MZTools to search into Access files.
Google to get the urls.

HTH

 

[PaulWilson]

Thanks Guus2005.
Once I know which database file has the info I want, I have numerous ways of extracting it. What I'm after, however, is a way to search through a variety of Access database files on disk to find a bit of VBA code or the name of a control. I'm not really interested in the data to be found in tables.

For example, if I use a bit of code I really like behind a form and want to find it easily later I might make add a comment in the VBA so I can find it later on. If I had some means of searching through closed databases (such as Windows search or Google Desktop) then I could find the code quite easily later on.

Currently, I can't find such a tool.

 

[Guus2005]

You can write a function which does that yourself using the (code)samples here on this forum.

Search recursive through your directory structure for mdb files. Open the database and search through the code using some of the code samples found here

It would be nice if you post the result in the code repository

Share & Enjoy!