Access 2003 hangs whenever I open a report in any DB

MS Access 2003 hangs whenever I try to open any report in any DB (on the network or my local drive). It even hangs if I try to import a report from another Access DB. The reports work fine on another computer. Rebooting Windows XP did not fix it.

My problems started right after Access hung while printing an Access report to a PDF file via Acrobat Pro 6. That hung Access.
LVL 1
gordonwwaughConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Are you *sure* that there is a Default Printer specified ?

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Mean in Control Panel >> Printers ?

mx
0
RgGray3Commented:
What is your service pack level on Win XP and Acc2k3

I am having a similar problem when I open Modules

Do you have Windows or Microsoft Updates turned on...

SP3's for both the OpSys and Office seem to cause alot of inconsistencies

I had updates turned completely off and I got a notification when shutting down that updates were ready to install....  and updates were MAGICALLY set to download updates.

This has been reported by a number of users and I found a posting on the internet that it started on Sept 10th...  
though I can't find a reference to it now....  Microsoft claims it did nothing wrong.

One of my programmers just had the same thing happen to him this week.....   His has always been turned off....  and suddenly updates are ready to install.

I am not sure that I can offer much more advice than what I am preparing to do over the weekend....

Shake the etch-a-sketch ....  Reinstall the operating system and Office....  patch it to SP2 levels....  and get back to work...

Sorry
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You might also want the Hot FIx:

Office SP3 Issues:
http://news.office-watch.com/t/n.aspx?a=657
Hot Fix:
http://office-watch.com/kb/?945674

----
0
gordonwwaughConsultantAuthor Commented:
Wow. My printers control panel won't open (it hangs). So maybe something went amiss when Acrobat hung while trying to print. I just lost my task bar, so I'm going to reboot now and try to fix the printers control panel. I'll get back to you in a few minutes.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Access reports require a Default Printer to be installed, or several different bizarre errors can occur.

mx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"so I'm going to reboot now and try to fix"

Do a Windows System Restore - from a point prior to this issue.  I've had that fix a similar issue in the past -... ALL printers suddenly disappeared !!!  Restore fixed it!

mx
0
gordonwwaughConsultantAuthor Commented:
Thanks for your quick response. I found that every app hung when I tried to print. The problem disappeared after I stopped and restarted the Windows print spooler.

I'll keep the Windows system restore in mind if the problem reoccurs.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.