I trying to save an Access 2013 report as an Adobe Acrobat document. When the application is run on my system, I do not receive an error. When this is run on the system where the application is scheduled to run, the following error is received:
"Error #2302: Microsoft Access can't save the output data to the file you've selected."
This is my statement:
appAccess.DoCmd.OutputTo(Access.AcOutputObjectType.acOutputReport, "My Report", _
"PDF Format (*.pdf)", "C:\" & gstrDateStamp & " My Report.pdf", True, "", , _
I have tried several things, which do not seem to have any impact:
- Creating an empty file and naming it what the Acrobat file will be named, so the file already exists.
- Set the autostart parameter to True or False
Any ideas you might have would be greatly appreciated!
Thanks In Advance,