Help Please - MS Access reports running very slow

[Guest]

Hi

We have an application (mde file) accessing a MS Access database file and generating reports. We have placed both these files on the server and access the application from a different PC by mapping the drive to the server. When we run a report with a few sub-reports, it is taking a very long time to generate. Whereas, when we put the same application and MS Access database on the same PC and access it directly, the same report with the same amount of data runs extremely fast. To give an idea of how slow the report runs from the server - it takes 21 minutes to generate completely when run from the server but just 3 minutes to generate completely when run on the same PC. This is happening at a client site

Please, help with this as I am not able to figure out why this would happen

Thanks & Regards
Saravanan.

 

[SA]

Saravanan:

Stop by the following web page and review the performance issues outlined
there, one of them will probably be the issue and clue:

http://www.granite.ab.ca/access/performancefaq.htm

Too, if you haven't split the database into front end / back end where just
the common data resides on the server, with the forms/reports/queries etc on
the local workstation, that will also impact performance greatly.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Hi,

We have an application (mde file) accessing a MS Access database file and

generating reports. We have placed both these files on the server and access
the application from a different PC by mapping the drive to the server. When
we run a report with a few sub-reports, it is taking a very long time to
generate. Whereas, when we put the same application and MS Access database
on the same PC and access it directly, the same report with the same amount
of data runs extremely fast. To give an idea of how slow the report runs
from the server - it takes 21 minutes to generate completely when run from
the server but just 3 minutes to generate completely when run on the same
PC. This is happening at a client site.