G
Guest
Reports I created in Access 2000 will not open in 2003. I can't even get to
them in design view. Can someone help me.
them in design view. Can someone help me.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
Cindy, this is probably a problem with the way the printers are installed.
In previous posts, people have described a problem with Access 2003 not
being able to recognise network printers that are seen by other programs.
The solution involves reinstalling the printer.
To verify that this is same problem you are experiencing:
1. Press Ctrl+G to open the Immediate window.
2. Enter:
? Printers.Count
If you get zero as the answer, Access is not able to see any printers.
3. Enter:
? Printer.DeviceName
If you get no response, Access is not able to work with the default printer.
Your network admin can probably take it from there. If you don't have a
network admin, you could try deleting the printer from your computer
(Printers in the Windows control panel), and then installing it from a list
as if it were a local printer. Then reconnect that printer to your actual
network one.
In previous posts, people have described a problem with Access 2003 not
being able to recognise network printers that are seen by other programs.
The solution involves reinstalling the printer.
To verify that this is same problem you are experiencing:
1. Press Ctrl+G to open the Immediate window.
2. Enter:
? Printers.Count
If you get zero as the answer, Access is not able to see any printers.
3. Enter:
? Printer.DeviceName
If you get no response, Access is not able to work with the default printer.
Your network admin can probably take it from there. If you don't have a
network admin, you could try deleting the printer from your computer
(Printers in the Windows control panel), and then installing it from a list
as if it were a local printer. Then reconnect that printer to your actual
network one.
G
Guest
I am having the same problem with our 2000/2002 databases in 2003 as well, I
did type the commands in to the Immediate window and it showed the proper
number of printers and also named the default printer as it should. Any
other thoughts? Thank You in advance for any help.
did type the commands in to the Immediate window and it showed the proper
number of printers and also named the default printer as it should. Any
other thoughts? Thank You in advance for any help.
A
Allen Browne
If it's happening in A2002, and the printers are showing successfully, then
it has to be another problem. The most likely cause is a corruption caused
by Name AutoCorrect.
Try this sequence:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact
3. Close Access. Make a backup copy of the file. Decompile the database by
entering 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"
4. Open Access, and compact again.
5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html
6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.
At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are
resolved.
If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
it has to be another problem. The most likely cause is a corruption caused
by Name AutoCorrect.
Try this sequence:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact
3. Close Access. Make a backup copy of the file. Decompile the database by
entering 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"
4. Open Access, and compact again.
5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html
6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.
At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are
resolved.
If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html