Access 2003 printing problem

[DBinPhilly]

Here's a weird one:
In a network environment with 12 workstations, one of the workstations had problems a few years ago when we moved to Access 2003 from Access 2000.
It refused to print. We were forced to move it back to Access 2000.

For various reasons, we moved this workstation to Access 2007, but because of certain incompatability problems between 2003 and 2007, we would prefer that all our workstations remain at 2003.

I again installed Access 2003 on the rogue workstation and again it refuses to print. It will not do a print preview either. When I click a button to print I get the following message:

The OpenReport Action was cancelled.


It allows me to do a File --> print but that doesn't help if I can't get a preview.

The computer is running MS Vista with an HP LaserJet 1020 printer

Any suggestions?

[OBP]

Can you manually open a Report?
The "The OpenReport Action was cancelled" message is normally associated with an error.
What is the VBA code that the Button uses?

[DBinPhilly]

I have both Access 2003 AND Access 2007 on the workstation. The program I am using is a mature system that has been in development for about 15 years.

Using Access 2003:
all program functionality works except printing. Every object can be opened in design view except for Reports. Attempting to open any report (about 200 available) elicits no response at all.

Using Access 2007:
all program functionality works including printing.

Another quirk:
If the program has been opened in Access 2007, it no longer functions properly in Access 2003. I must re-copy a 'template' version of the program onto the workstation if I want to use Access 2003.

Hope I've given you enough information to form an opinion. I suppose it has to do with DLL's, maybe.

[OBP]

You may be correct about the dlls, Office 2003 and 2007 are not compatible in that respect.
Have you tried opening a new Blank Access 2003 database, import everything in to it from the old one and then Compact & Repair it to see if that will allow you to open a Report in Design View?
Do you have an old Access 2000 version that still works?

[DBinPhilly]

I will try option 1.

I'll create a new database in 2003 and import the objects.

I no longer have a version of 2000.


Thanks for your input.

[DBinPhilly]

creating a new database in 2003 didn't work. It refused to execute visual basic commands such as:

DoCmd.Maximize
I've gone back to 2007 to have a working database, but I'm not sanguine with the outcome.

If you have any other ideas, I'm all ears. Thanks for your help.

[OBP]

It sounds like you have not got a "complete" install of Office 2003, which includes Visual Basic etc. I know you definitely can't run 2003 & 2007 on the same computer at the same time, you have to re-install them each time you want to run a different one.
Did you do a complete Office & Access 2003 Re-install?

[DBinPhilly]

I did a total install of MS Access 2003 only. I need the 2007 Excel that is on the workstation because of emailed spreadsheets that don't work in 2003.

So I did not uninstall Office 2007. But I did a total install of Access 2003 onto a different path. And Visual Basic appears to work. The code is there and I can do a successful compile. It just won't run.

[OBP]

Will the Reports now open in design view?

[OBP]

See this link for establishing your Jet version and other Access info
http://www.everythingaccess.com/tutorials.asp?ID=Code-for-Splash-screen-with-version-information#GetJetVersion