Query All Records / Tables?

[Guest]

Is there a way to search for a unique ID across all tables? All ID's are
unique throughout the database and I need to search the entire thing for a
single ID. Using Access 2003.

 

[Guest]

You would need to construct a UNION query that joins every table in the
database. Difficult to maintain if you are adding new tables and will run
slow.

Why do you have unique ID's which you need to search in multiple tables? Are
you doing something like a table for each month or each piece of equipment?
If so, that's the main problem. All like items should be in the same table.