searching across databases

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

What is the best way to search for names across several databases? And then
view the record.
 
Are you talking about databases or tables? A database is a collection of 1
or more tables.
 
I do mean databases. I have a Student, client, and Inquiry databases and I
was wondering if I can search across all of them somehow? Thanks Arvin.
 
Marie said:
I do mean databases. I have a Student, client, and Inquiry databases and I
was wondering if I can search across all of them somehow? Thanks Arvin.
Click to expand...

You could build a front-end which linked to tables in all three
databases, and create a UNION query and filter that. (Although some
things you can't do with Unions, and I haven't tried this out!).

Bit of an odd thing to do. Suggests your three databases ought to be
one, perhaps.

Phil, London
 
It is possible to search in an external database. The SQL in the query might
look something like this:

SELECT *
FROM [C:\Database\Data.mdb].tblAddresses;

Notice the square brackets around the path to the table. You can use code or
a union query to return your results. You can also link the tables from the
other databases and build a union query, then search within that query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Back
Top