searching an entire db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all. I am working on a fairly obscure and poorly designed db at the
moment.

I am trying to find a particular term (Personal Search - Philosophical
Questions) however I dont not know which table or field within it in which it
is stored.

There are approx 50 tables......some of which are extremely large with many
fields. Can anyone suggest a way of identifying where the above value is
stored?

thanks for reading.

Gav
 
A rough but workable method might be to export each of the 50 tables to
CSV format, then open the file in Excel, or Word, and do the search
from there!

You could of course write VBA & DAO code to search every field in every
record in every table - but if you don't know how to do that already,
it would probably take you longer than the manual method suggested
above.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
Hi TC.

Thanks for the reply. Managhed to find a neat wee utility on the net that
works briliantly.

Cant believe there is no built in facilty for this though.....crazy.

Anyway, thanks for the reply.

Gavin
 
Cant believe there is no built in facilty for this though.....crazy.
Click to expand...

Well, it would never be needed in a well-designed database (where
there are well defined places for each type of information).

Your situation (of having to work with a faulty and ill-documented
table design) is more common than anyone would like, but I don't see
having Access designed on the assumption that it's typical!

John W. Vinson[MVP]
 
Back
Top