Find a record across tables

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

Guest

I have a scenario where there are around 50 tables in a MDB file. i need to
find a particular record which is stored in any of the 50 tables.

Please suggest a solution

thankyou

AMIT
 
No offense, but it sounds as though your database isn't very well designed:
not knowing which of 50 tables something could be in doesn't sound right!

Are the 50 tables identical, except for one thing? For instance, do you have
one table for each department in a company, or one for each product that's
sold, or something like that? Odds are you should have a single table with
one additional field to distinguish that additional dimension.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add new record from linked table 9
acnewrec? 1
Access Dcount (multiple criteria) 3
MS word Find and Replace using Regex - Help required 0
Access Compare records in same access table 0
Excel School Time Table Teachers and class 0
Bloating 2
finding same fields in access tables 3

Back
Top