reports created with access 2002 do not work in access 2003?

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

Guest

I'm transferring data base maintenance responsibilites to another individual.
I'm using Access 2002 - he is using Access 2003.
I gave him a copy of the data base via a diskette.
When he tries to produce a report with Access 2003, the process asks for
parameter (?) that wasn't a part of the report process with Access 2002.
The report generated is filled with "error" rather than the correct info from
the data base which works very well with Access 2002.
Any suggestions?
Thanks.
 
There is a latent problem within the A2002 database.

1. Open it in A2002. Uncheck the boxes under
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

2. Compact it:
Tools | Database Utilities | Compact

3. Close Access, and make a backup copy of the mdb file.

4. Decompile 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"

5. Open in A2002 again, and compact again:
Tools | Database Utilities | Compact

Now close Access and copy the file to the A2003 machine again:

1. Open in A2003. Make sure that Sandbox mode is turned off:
Tools | Macro | Security | Low
If you need further help with that, see:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

2. Press Ctrl+G to open the Immediate Window.
Choose Compile from the Debug menu to check that everything compiles.
 
Back
Top