Access 2003 reports will not open and I cannot create new ones !

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ahve spent a long time creating a trainnigb database for my company and now
the reports are not working.
there are a few I can still open but I cannot create new or open some of the
reports.
Untill now I have not had a problem and all of the reports were working
 
Is there a default printer defined on the computer? If not, try adding the
Fax or Generic Text printer just to have a printer defined. If the current
reports have had a specific printer defined and that printer no longer
exists on the computer, you may need to change it to Default or specify
another printer.

If this isn't it, I would suspect corruption of some sort. Please see this
link for options to solve this. Make a copy of your file first and be
prepared to restore from a backup.

http://allenbrowne.com/ser-47.html
 
I'm not sure, because you said that you can open some of the reports, but
this problem occur usually when someone is trying to open an MDB on a
cumputer that doesn't have a printer defined in windows.

Check if you have a defaulte printer defined in windows.
 
Hi Wayne
Thank you for the suggestions.
I do have a printer assigned as the default printer.
However I am sharing the database with collegues.
If they were to try to open a report and have not had a default printer
assigned would this cause the problem?

These are all of the different responses I get when trying to open a report
from a form Button I have created
1. I get a message box saying "The OpenReport action was canceled." no
options just an OK Button.

2. I get a message "This document was previously formatted for the printer
on
IP_10.20.13.36, but that printer isn't available. Do you want
to use the default printer \\bls13dc10\13lbw002468hp?" I can click on OK ,
Setup.. or Cancel and I get the same Message "The OpenReport action was
canceled."

If I try to open the reports from the database window I either get a report
to open of absolutely no responce at all.

When I try to view the report in design view this also does nothing on some
reports but does work on others.

I hope that someone can fathom this out for me.
 
i think we had a similar problem at my school. it took me a while to
figure out why.


is your default printer connected over a network?
is your default printer an HP?
if you are over a network are the computer OS's the same?
are the drivers current?


the problem i finally found had to do with a driver failure / conflict
with HP printers when trying to print from one version to a print server
with a different version (driver and os). updating the drivers every
where solved the problem. for the longest time we had to set the
default printer to anything other than the 1 printer that we could print
to. this is a documented problem on the HP web site i think.


Hi Wayne
Thank you for the suggestions.
I do have a printer assigned as the default printer.
However I am sharing the database with collegues.
If they were to try to open a report and have not had a default printer
assigned would this cause the problem?

These are all of the different responses I get when trying to open a report
from a form Button I have created
1. I get a message box saying "The OpenReport action was canceled." no
options just an OK Button.

2. I get a message "This document was previously formatted for the printer
on
IP_10.20.13.36, but that printer isn't available. Do you want
to use the default printer \\bls13dc10\13lbw002468hp?" I can click on OK ,
Setup.. or Cancel and I get the same Message "The OpenReport action was
canceled."

If I try to open the reports from the database window I either get a report
to open of absolutely no responce at all.

When I try to view the report in design view this also does nothing on some
reports but does work on others.

I hope that someone can fathom this out for me.
Click to expand...


--
Charles E. Vopicka's (Chuck) : (e-mail address removed)

Database Management, GIS Specialist and Research Assistant

Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America

Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)

:-) HAVE A NICE DAY (-:

"UNLESS" (The Lorax, by Dr. Seuss)
 
Thank you Charles.
I think you have probably hit the nail on the head.
We have been upgading Os's and Office accross our network and we also have
many print servers.
I came across one printer I could use a moment ago which was a PDF Creator
printer. Unfortunately not all of our users have this particular printer. i
think it will be a temporary fix untill we have upgraded everyone to the same
OS, Office and SP's all round.
Thank again, I now have some options to address.
Kindest Regards
 
Back
Top