Search a string in complete MS Access database

I want to search a 开发者_运维问答string in whole MS Access database. How can I do this?

What you are looking for is called full-text search.

According to this SO question, MS Access does not have this capability.

Add a reference to ADO; for each table create a command using "SELECT F1, F2 ... FROM Table" (F1, F2, ... are the char/text fields of Table); for each table get the corresponding recordset; loop over the recordset, using .GetString to get the values in one string; use Instr() (case sensitivity?) to check whether the string contains your needle (delimiter!).

But why on earth you want to do that?

If you're talking about searching for the names of reports, queries, tables, modules, etc in your Access file, then try SpeedFerret