multiple database search

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

Guest

I have a few (flat file) databases that I have migrated from file maker to
access. All similar fields in each table are of the same value. I need to
make a form to search all (5) databases. I do not want to edit in this form
just bring up records.
Any suggestions? (access for dummies and the complete reference did not
help).
 
Do you really mean "search all (5) databases" or do you actually want to
search 5 tables.
You can create a union query of tables with the same (or very similar)
structures. This allows you to search records from multiple tables.
 
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

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Difference in size of actual access database and its backup 0
Access Need help in making asset history in my current database. 1
Trying to reduce number of fields 0
Access Microsoft access database(creating a search engine form) 0
table / form design help.. 2
Access Importing csv daily files into access 2007 1
{Q} How to modify record in M Access database? 0

Back
Top