Accessing database

  • Thread starter Thread starter Stefan
  • Start date Start date
S

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
 
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.
 
Back
Top