2002 macros in 2010

[caruncles]

I have a 2002 Access DB that is the backend of some legacy VB6 programs. One of our most critical apps is running on a computer that is 16 years old running XP. I'm trying to get the system running on a WIN 7 box with ACCESS 2010 installed. The only part that seems to blow up is report printing. I get the error "A custom macro in this report has failed to run, and is preventing the report from rendering". I get this error when trying to run the .mdb with ACCESS 2010 and also if running the same database converted to a 2010 .accdb. I don't want the easy answer because i want to learn something, but could someone please tell me how to first find, then troubleshoot the offending macro?

 

[pbaldy]

Look at the properties of the report on the Events tab. See if there are any macros or VBA called. The db has to be in a trusted location for either to run.

 

[caruncles]

Thank You Sir! I'll take a shot at reducing that possibility!

 

[pbaldy]

No problem! By the way, I think in 2010 you can also get code to run by clicking once on the "Enable Content" button.