If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
reports created with access 2002 do not work in access 2003?
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. |
#2
|
|||
|
|||
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/assistan...roduct=acc2003 2. Press Ctrl+G to open the Immediate Window. Choose Compile from the Debug menu to check that everything compiles. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jerry Z" Jerry wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2003 mde vs Access 2002 | rob | General Discussion | 3 | August 27th, 2004 05:24 AM |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
from Access 2002 to 2003 | vb | General Discussion | 0 | July 12th, 2004 03:13 PM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |