Problem with Access 2007 – Reports Open Very Slowly

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.

Problem resolved! By digging more into other Posts, I discovered another new
user having the same problem. It was the default printer setting that needed
to be changed. In the future, I will dig deeper into other posts before
posting a question.

"Brad" wrote:

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.