Finding a field inside Multiple Tables

T

Thomas [PBD]

Just a general random question. My co-worker is attempting to find a field
located in a table, but doesnt know which table it is located in.
There are about 40-50 tables in her database, and going through one by one
would be ludicrous. IIf (heh) anyone knows a way to do so, without the
manual labor, I would greatly appreciate the heads-up.
 
J

Jeff Boyce

Thomas

There are both commerical and for-free database analysis tools available.
Have you tried searching on-line?

Access also has a documenter tool that can print out table/field definitions
.... but someone would still have to read all those.

How is it that your coworker knows there is a field? Is there a clue via
that path to the table it lives in?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
T

Thomas [PBD]

Jeff,

The way she knows that there is a field with the relating name, is that
there are queries being based on the information at hand, she needs to find
all the tables with the field name. I know that tables are not supposed to
contain like information in multiple tables, but with the way that it is
built it creates tables with selected information.

The database is just too large to reconstruct at the moment, it would take a
lot of time and effort to be able to do so. I think the documenter tool
would be the most useful to do what she is looking for, eventhough she would
have to go through and read it all.
 
J

Jeff Boyce

Thomas

If she has a query to look at, the query names the table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
T

Thomas [PBD]

Jeff,

Oh I know this. But, there are just as many tables as there are queries.
Maybe more queries. Therefore we didnt know which query was creating or
using such a field. I used the documenter to elaborate the queries SQL, so
that I could export it as a TXT file and search for the field I was searching
for.
 
Top