B
Brad
At work, about 1 month ago, I received a new Dell Precision (2.66GHz with 2GB
RAM).
Included in this purchase was Microsoft Access 2007.
Here is the information on the “About†page…
Microsoft Office Access 2007 (12.0.6211.1000) SP1 MSO (12.0.6320.5000)
The installation of Access went fine. The product works great with one
exception.
Opening up a small test report that is obtaining data from a small test
table (5 records) is very slow.
Forms and tables open up quickly (sub second). Reports take about 10 or
more seconds to open. I have experimented by setting up several small
databases and in all cases, the reports open very slowly. This slowness is
observed every time I first open the report. When switching from Design View
to Report View I also see this slowness.
Here is the interesting part. For a test, in order to better understand
this problem, I downloaded a 60-day trial of Access 2007 at my home on an
older Dell Dimension (1.7 GHz with 768K of Ram). I then e-mailed the test
database from work to my home PC and did the exact same tests. I do not see
any of these slowness problems on my home PC with the trial version of Access
2007. All of the little reports were displayed in sub-second response time.
Switching between Design View and Report View was also sub-second on my home
PC.
I have not changed any of the Access 2007 parameters. I have run a virus
check as was suggested by another person. No viruses were found.
The test databases that I am working with are all located on my PC and not
on the network. When I have run my timing tests, I have always closed all
other applications such as Word and Outlook.
I have opened up the Windows Task Manager and observed the processes running
when I open up a report. When I do this I see MSACCESS using from 0% up to
2% of the CPU and “System Idle Process†using about 98% of the CPU as I wait
for the report to be displayed.
Other products such as Word, Excel, and Outlook run great with very good
response time. I am only seeing this slowness issue in Access 2007 reports.
It is very frustrating to have this type of response time as I try to design
a report and need to switch between Design View and Report View many times in
the creation of a new report.
Thanks for your help with this problem.
RAM).
Included in this purchase was Microsoft Access 2007.
Here is the information on the “About†page…
Microsoft Office Access 2007 (12.0.6211.1000) SP1 MSO (12.0.6320.5000)
The installation of Access went fine. The product works great with one
exception.
Opening up a small test report that is obtaining data from a small test
table (5 records) is very slow.
Forms and tables open up quickly (sub second). Reports take about 10 or
more seconds to open. I have experimented by setting up several small
databases and in all cases, the reports open very slowly. This slowness is
observed every time I first open the report. When switching from Design View
to Report View I also see this slowness.
Here is the interesting part. For a test, in order to better understand
this problem, I downloaded a 60-day trial of Access 2007 at my home on an
older Dell Dimension (1.7 GHz with 768K of Ram). I then e-mailed the test
database from work to my home PC and did the exact same tests. I do not see
any of these slowness problems on my home PC with the trial version of Access
2007. All of the little reports were displayed in sub-second response time.
Switching between Design View and Report View was also sub-second on my home
PC.
I have not changed any of the Access 2007 parameters. I have run a virus
check as was suggested by another person. No viruses were found.
The test databases that I am working with are all located on my PC and not
on the network. When I have run my timing tests, I have always closed all
other applications such as Word and Outlook.
I have opened up the Windows Task Manager and observed the processes running
when I open up a report. When I do this I see MSACCESS using from 0% up to
2% of the CPU and “System Idle Process†using about 98% of the CPU as I wait
for the report to be displayed.
Other products such as Word, Excel, and Outlook run great with very good
response time. I am only seeing this slowness issue in Access 2007 reports.
It is very frustrating to have this type of response time as I try to design
a report and need to switch between Design View and Report View many times in
the creation of a new report.
Thanks for your help with this problem.