We have an Access database that's used to export some invoices as Excel files and also print them to a PDF. All of this happens in one macro. There's nothing in the macro except OutputTo and PrintOut commands. The OutputTo commands run a report and export it as an Excel 2003 file. This works all fine and dandy on my computer and worked fine on my co-worker's machine until we upgraded to Access 2007. Now, everytime he runs the macro it gets a couple steps into the script and fails. I've discovered that this is because it is deleting the sql from one of the stored queries. The querydef is still there, it just no longer has any sql associated with it. I'm totally unable to reproduce this on my machine and really have no clues as to why this would be happening since there is nothing running that should modify any data or structure. Any ideas?
Macro is Deleting QueryDef body
- Thread starter ianlee74
- Start date
