Edit in MDE

[Hutch]

So i have this report i print out with a where condition that automticaly selects what pages i want to print in accordance to the record i am on, Also a macro renames the report to the current record i am on, Prints it to a certain file, then renames it self, all by the click of a button and with out me having to input any additonal data everytime i push "print" the problem is in MDE i cant rename the report so it faults everytime. Any thought's?

[nico5038]

Hmm, perhaps a macro limitation, what happens when you convert the macro into VBA code and use that instead ?

Nic;o)

[missinglinq]

What version of Access? I think ver2003 and ver2007 have security settings that, depending on how they're set, can prevent macros from working.

[Hutch]

I didnt think to convert the Macro in VBA, i will try that. But i am pretty sure it's due to the fact i am trying to rename a report in a MDE and not just a standard Front End, Which it works perfectly well in. How can i Change security settings in an MDE? i am using 2003