I have an application on two or more machines which have identical MS Access
2000 databases. The records in each database are unique to the
machine(unique terminal number in each table key). I need to report on a
union of all of the tables for all machines. Is there a simple way of doing
this(create a union query on multiple data sources???). Or must I create a
new reporting database and append all records to it and then report on it?
I need the data from all machines at once in order to create summary
information in my reports.
I've thought of replication, but am worried about application stability and
database bloat. For some reason, setting up replication causes the
databases to grow expontentialy( a 958K database becomes a 10.3 MB
Anybody having any ideas or experience with a similar problem, I could
really use the benefit of your insight......
Shane G. Brodie