searching across databases

[Marie]

What is the best way to search for names across several databases? And then
view the record.

 

[Arvin Meyer [MVP]]

Are you talking about databases or tables? A database is a collection of 1
or more tables.

 

[Marie]

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.

 

[Philip Herlihy]

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.

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

 

[Arvin Meyer [MVP]]

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