Accessing database

[Stefan]

I have an identical series of databases each linked to its
own set of data. Each set of data is for a different
client and contained within medisoft (medical billing
software)

To run the month end reports I have to open up each access
database and the report for each client.

Is there a simple way to program access to open up and run
this report for each of the databases automatically?

Thanks is advance for any suggestions

 

[Guest]

Hi Stefan,

What about the Windows Scheduler? One task for each database.

Or

You could link the necessary tables from the different counterparty databases into a separate database from where you run the reports, use the Autoexec makro.
In addition you could set up a table where you track when the reports were produced the last time.