problem with reports Access 2003

Sometimes reports in Access 2003 do not work and will not open in preview or design mode. If I close Access and reopen it, the reports sometimes work fine. This is happening on a Dell Latitude E6410 64 bit computer running Windows 7 professional SP1. The same database always runs fine on a Motion J3500 32 bit running Windows 7 Home premium SP1 and a Fujitsu Stylistic 5200 32 bit running Windows XP.

There are no missing references. I thought the reports were corrupted so I copied them from the working databases but no help. I also tried moving the databases that work on the other computers but then the reports don't work on this (the Dell) computer. I also decompiled, repaired and recompiled the database. And then sometimes when I run Access on this computer, it runs fine.

Any  ideas?

BTW: I do have Access 2013 but this database has 33,000 lines of code and I don't want to spend the time to upgrade it which is why I am using 2003 with it.
LVL 39
thenelsonAsked:
Who is Participating?
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.

Robert ShermanOwnerCommented:
What happens when you try to open a report and it doesn't work?  Do you get any sort of error message?   Does Access hang up or crash?   When reports aren't working as you say, does that apply to all of the reports in a database or just certain ones?    Are the database files local or stored on a network share?
0
thenelsonAuthor Commented:
The reports just do not open, no error message. Not all reports have this problem. Access does not hang up or crash. The database is split to a front end and back end. Both files are local in the same folder in each computer.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
I would also ask:

 When did this start?

 Is it only one station that does this?

 Has anything recently changed?

 Usually with reports, issues with opening in design/previewing are related to printer drivers.   Also make sure that all printers and mapped drives are available in Windows.

Jim.
1

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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Robert ShermanOwnerCommented:
Also, when you run into these reports that won't open, what happens if you do a right-click > Open (as opposed to a double-click) and/or right-click > Design View.   Check to see if either of those respond as expected or not.
0
thenelsonAuthor Commented:
>Usually with reports, issues with opening in design/previewing are related to printer drivers.

That's the problem! When the printer "HP Officejet Pro 8600 (Network)" is set as default, the reports don't work. When another printer is set as default, they work fine. Now the question is what to do with the printer to fix this issue. I have had other problems with this printer so I have completely removed and reinstalled it abut 6-7 times. The other problem I am getting is I have this printer at the office and an HP D110a printer at home. When I install one printer, it disables the scanner of the other and vice versa. I have called HP twice about this problem and they stated it is a problem with the computer. I have called Dell and of course they have said it is an HP problem. This is a different question than this one. Any idea what I can do to resolve the Access problem with the printer?
0
Robert ShermanOwnerCommented:
Check in Devices and Printers under control panel to see whether the printer is online.  Are you able to print to it at all from Access or any other application?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Any idea what I can do to resolve the Access problem with the printer? >>

 The best you can do on the Access side it leave it set to "default printer" and then change the default in the OS when at work vs home.

or

Setup the same printer and driver at both home and office (ie. Something like a generic HP LJ III), and set the Access report to that specific printer.

Jim.
0
thenelsonAuthor Commented:
It was a printer problem - thanks!
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.