Publish to pdf can't save the output data

I had the same issue on Access 2007 when I migrated to Windows 7.

The strange thing was that sometimes it worked, other times it didn't.

If I kept trying to export to PDF, eventually it would do as it was told and I'd get an exported PDF.

What I found was that if the file already existed, the PDF would save as expected.

To get around the issue, I wrote a macro to firstly create an empty file then output as PDF.

Here's my code:

    Dim fs As Object

    Dim TextFile As Object

    Set fs = CreateObject("Scripting.FileSystemObject")

    Set TextFile = fs.CreateTextFile(DestPDF, True)

    TextFile.Close

    DoCmd.OutputTo acOutputReport, MyReportName, acFormatPDF, DestPDF

Good luck!

Fixed by reverting to restore point prior to Windows update & Microsoft Fix It 50792.

I am trying to publish a report to a pdf in Access 2010.  When I let it publish to the default location, My Documents, it works fine.  When I try to save it anywhere else (desktop,  specific folder) I get an error message saying "MS Access can't save the output data to the file you've selected."  None of the reasons it lists are true (permission, file open, etc.).  Can someone please help? I looked this up and the MS help for previous versions said something about the Output file, but I don't know what this refers to.  I need this to be as easy as MS promised.  Thanks.

Same problem, except get error message no matter where I try to save published file. This feature was previously working fine -- the only way I've found of successfully retaining hyperlinks in PDF version of Access report. I'm wondering if recent installation of Microsoft Fix It 50792 may have created the problem, or perhaps the previous Windows update.

No code - I am clicking on the "PDF or XPS" button.  It is not just publishing to my desktop, its to any folder other than the default of "my documents."  Everything else works fine.

Hum, are you using code to do this, or the access user interface?

I don't see why this would not work. Can you create and save things like excel, or word documents on your desktop ok also?

--

Albert D. Kallal  (Access MVP)

Edmonton, Alberta Canada

*** Email address is removed for privacy ***