Help…

[Danc383]

I need to create an access database that would query Multiple Access
Databases

the Multiple access Databases all have the same fields, they are item
Databases containing product info Code, Supplier, cost, name, barcode ect
ect...

the purpose of the access database to check all the other Databases for
any differences from the master and flag and variance with a indicial
Database.


Dan

 

[John W. Vinson]

I need to create an access database that would query Multiple Access
Databases

the Multiple access Databases all have the same fields, they are item
Databases containing product info Code, Supplier, cost, name, barcode ect
ect...

the purpose of the access database to check all the other Databases for
any differences from the master and flag and variance with a indicial
Database.


Dan

Ummmmmm.....

WHY!?

This is making your job VASTLY harder. Why are there multiple databases? Are
they on the same machine, or on a network? Are they actually multiple .mdb
filed - databases, containers for multiple tables, forms, reports and other
objects, or are they multiple tables in one database?

You can use File... Get External Data... Link to link to a table in another
database (on the same computer or on the same fast, stable LAN) and create
queries... but the entire architecture is deeply suspect here!

John W. Vinson [MVP]