T
tim
I have an Access 2000 application linked to SQL Server 2000 that
requires many custom reports for each customer that uses the
software. I created a separate MDB that runs all my custom reports so
I do not have to update the MDE everytime there is a report change.
The MDB gets opened through AUTOMATION. The problem I am having is
that there are so many custom reports the MDB is getting very large
and is slow to open. If I remove all the unwanted reports for a
specific customer, the reporting gets very quick. The problem with
this is that I will have to maintain over 100 MDBs if each customer
has their own report MDB.
Any suggestions?
requires many custom reports for each customer that uses the
software. I created a separate MDB that runs all my custom reports so
I do not have to update the MDE everytime there is a report change.
The MDB gets opened through AUTOMATION. The problem I am having is
that there are so many custom reports the MDB is getting very large
and is slow to open. If I remove all the unwanted reports for a
specific customer, the reporting gets very quick. The problem with
this is that I will have to maintain over 100 MDBs if each customer
has their own report MDB.
Any suggestions?