Search a word in whole database

  • Thread starter Thread starter Nik
  • Start date Start date
N

Nik

Hi, I'm trying to search a word in all fields of all tables in a database.
Is it possible to get such a query?


Table1
fields1 ----- fields2 ----- fields3

Table2
fields1 ----- fields2 ----- fields3 ----- fields4 ----- fields5

Table3
fields1 ----- fields2

The word I'm searching may be in Table1-fields1 AND/OR Table2-fields3 AND/OR
Table3-fields1 AND/OR etc...
So I would like to get the ID (which is AutoNumber in each table) of the
record where the word is.

Thank for your help.
Nik.
 
Nik

So, if I tell you that the AutonumberID is 12345, how does that help you?
Which table is it in? Which field in that table?

When I see a request to "search everything for a word", I suspect that the
database is a copy of a spreadsheet. I'll suggest that your data structure
is probably in need of serious normalization, but I don't have much
information to go on.

More info, please ... as in "what's being stored in all these tables, in all
these fields?
 
Back
Top