Searching multiple databases

K

Kevin

I have about 6 different databases. Is there a way to search all of them at
one time? Is there such a thing as a "master form"?
 
B

Brendan Reynolds

You could create a new database with links to the tables in the six
databases, and create a union query on the six linked tables.
 
M

Mike Labosh

I have about 6 different databases. Is there a way to search all of them
at
one time? Is there such a thing as a "master form"?
Click to expand...

If you're searching the tables for records / values, you could make a 7th
empty database, link all tables of interest in the other files. (File ->
Get External Data -> Link tables) and then make a form that let's you query
for whatever you need.

If you are trying to search for objects, such as "list the mdb files that
have this type of db object whose name looks like this" Then I have a
fairly easy utility for the asking:

mlabosh at hotmail dot com

--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane
 
Top