If you specified a particular printer in Access 97, try setting Default
Printer for each report under Page Setup, and then convert again.
If that does not work and the reports have code in their modules, try
decompiling in Access 97 before conversion. Close Access. Backup the file.
Open a command prompt, and enter something like this (one line, including
the quotes):
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"
After conversion, uncheck the off Name AutoCorrect boxes under Tools |
Options | General. Then compact.
If none of that succeeds, try creating a new (blank) database in Access 97,
and import the reports: File | Get External | Import. Then delete the faulty
reports from your Acc 2003 database, compact, and import the reports from
the new mdb.
Note that you must have some printer installed (not necessarily present)
before Access can handle the reports for you.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
Don said:
Hello, I have just converted a Access 97 application to Access 2003. I
have most of it working but having major problems with the reports. Most of
them I can't even open into Design mode. When I press Design it simply does
nothing.
