A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2004, 06:11 AM
Jerry Z
external usenet poster
 
Posts: n/a
Default 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  
Old September 24th, 2004, 07:27 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:08 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.