Reports not working Access 2003

[Guest]

I just installed MS Access 2003 with SP1. My reports in my Access 2000
database do not work. If I click on the reports, nothing happens.

Also, if I choose File...Print from the Access database, nothing happens. I
do have a printer installed and I've also rebooted.
Thank you.

 

[Allen Browne]

Hi Nancy

You have a printer installed, but Access doesn't see it. Hmm: there's been a
couple of people reporting this lately with A2003, particularly with network
printers.

Open the Immediate window (Ctrl+G), and ask Access information about the
printer, e.g.:
? Printers.Count
How many does it say you have?

Then try:
? Printer.DeviceName
This should give the anme of your default printer.

Then try:
? Printers(0).DeviceName
which should give the name of the first printer you have.

Does this give you any useful information about what's going on? Please post
a followup to this thread if you're still stuck.

 

[Guest]

Hi,

I've got the same problems.

I cannot open reports on an Access 2000 file.

I've checked if access was seeing my printers from the Instant Window and
it's Ok.

I guess if the file were corrupted I won't be able to open and work with it
from Access 2000, but I can, so the problem must be related to opening this
file with Access 2003.

Can you help me?



Sorry about my poor english.

 

[Allen Browne]

Suggestions.

1. Use Access 2000 to decompile the database. Enter something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

2. Uncheck the boxes under:
Tools | Options | Name AutoCorrect
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Compact the database.

4. Now use Access 2003 to create a new (blank) database:
File | New

5. Turn off Name AutoCorrect in the new database.

6. Import everything from the old database:
File | Get external | Import

7. Open a code window, and set just the references you need. More info:
http://members.iinet.net.au/~allenbrowne/ser-38.html

8. Still in a code window, check that the database compiles:
Debug | Compile.

If you still have the printer problem after that, the problem is with the
way the printers are installed in Windows.

 

[Guest]

Hi Allen,

I've tried what you told me to do but there are no positive results.

Then I tried this on other computers with Access 2003 and failed too.

Then I tried to create a new access file, create a table with some data, and
create a report, but it failed too. I can run te assistant but when I click
the 'finish' button it says that the assistant failed to create the new
report. (the same results in different computers).

These computers are equiped with XP Professional SP1 (I can't use SP2 until
the central office tests it and says it's OK) and Office 2003 professional.

 

[Guest]

I have tried everything also to no avail. However, I have a collegue that has
a computer that has had nothing but 2003 on it and my database works fine on
that one. I now know that my database is still good. Everyone that I have
tried this on seems to have upgraded from Access 2000. Any other sugestions?

 

[Guest]

I have the same problem I can't get reports to create or view in Access 2003.
I can't even create a new database and reports from scratch.

 

[Guest]

Hi Nancy,
I had the same problem. I found that when I clicked on reports nothing
happened too but I was able to fix it after I reinstalled a different
printer. You can test this out by deleting your current printer and then
open the reports see if that opens. In m situation it worked and then I
added the printer back but with different drivers.

Hope that works
Ryan

 

[Allen Browne]

These symptoms are much more severe than merely printing, and represent
either a bad installation of Office 2003, or inadequate permissions.

If you are working on your own computer where you log in as an
Administrator, reinstall Office.

If you are working in a corporate environment, contact your network
administrator with the issue. They will log you in as a local computer
administrator. If that solves the problem, they will then adjust your
permissions so Access works for you.

 

[Allen Browne]

If you cannot even create a report, there are a couple of possible causes:

a) Bad printer driver
As Ryan suggested in his reply to Nancy in this thread, the printer driver
can be the problem. Go to Printers (in the Windows Control Panel) and add a
new printer. Choose a printer you've heard of, but a different brand from
yours. (You do not need to buy a printer to try this, and you can remove it
again after this test.) Install it, and set it as your default printer.

Can you create a report now? If so, there is something wrong with your
original printer driver. Delete it, and try reinstalling it, or get an
updated driver for it.

If the other computers you tried this on all use the same default printer,
it is still likely that this is the problem.

b) Windows Permissions
Ask your IT dept to log you in as a local computer Admin. If this solves the
problem, they have not given you adequate permissions under Windows.

 

[Allen Browne]

Good troubleshooting. The database is fine.

The likely cause is the printer driver in your work environment, or
inadquate Windows permissions. Both issues require the attention of your IT
people.

 

[Guest]

I deleted my default network printer. Instantly, the reports feature and the
print feature started to work in Access 2003. Thanks for all the help.