Can't open reports modified in 2003 on 2000 user's PC

[sparkyrose]

Hey,

I have a Db in 2000 file format. During development my IT dept upgraded me to Office 2003 and I continued to work on the Db. I have posted the Db and 2000 users can open the Db fine, but attempting to run any reports seems to cause Access to 'encounter a problem' and freeze up.

Eventually everyone will upgrade to 2003, but in the meantime is there an easy way to fix the problem?

 

[gemma-the-husky]

perhaps its something in the code

access2003 uses DAO by default, but Access2000 used ADO. perhaps this is causing the probelms.

Can you trace the program execution and find whats causing the issues in A2000

 

[RoyVidar]

This sounds like corruption, but first...

If you use some methods available in 2003 that isn't implemented in 2000, I think you should get some compile or runtime error, but the "sorry for the inconvenience" message would normally have other causes (like for instance corruption).

But, you could of course check whether you're using the WindowMode or OpenArgs paremeters of the OpenReport method. Those are not available in 2000, i e

DoCmd.OpenReport "myrpt", acviewpreview,,"blah = 'foo'", acDialog, "testing"

should work in 2002+, but not in 2000, (where those two aren't implemented), you'd need only

DoCmd.OpenReport "myrpt", acviewpreview,,"blah = 'foo'"

Else, you could try comment most/all code from the report, then add incrementally until you find the culprit. Try debugging in the 2000 version.

Anyway, to "repair" corruption, and before any deployment, I will always /decompile on the oldest version (which is 2000 for me too). See for instance Tony Toews page http://www.granite.ab.ca/access/decompile.htm for step by step instructions. Note - between step 2 and 3, exit all instances of Access, reopen the database while holding Shift, to be sure all compiled bits are removed by the compact.

 

[sparkyrose]

Thanks for the replies. I don't really know what happened but it seemed to fix itself. 2000 users are happily opening the reports.

Strange but true!