PDF report no longer generating for some Access Database users

[Liann29501604zgoe]

I maintain an Access DB for approx 12 users.  I have 3 users with Adobe Acrobat Pro - 2 of them (including me) could generate a PDF Despatch Report from the database up until Monday 17th April.  The 3rd Adobe Pro user has the same version of Adobe Pro and is able to generate the PDF Despatch Report from the same database without issue.  I have 2 other users who are able to generate the PDF Despatch report via a VDI - they're using Adobe Reader DC.   When I run the report in the database I get Run Time Error 2501 and the line of coding in the debugger relates specifically to an output command and the PDF format.  On the evening of 17th April, I remember I tried to open a different PDF and a pop-up appeared advising that Adobe had to update first.   After this point, I haven't been able to run the reports. I've compared Adobe Pro versions for the 3 of us and we all have the same version (2023.001.20143).  The only difference seems to be that 2 of the 3 of us with Adobe Pro have Adobe Sync files which updated on 17th April.   I don't know anything about the Adobe Sync files and a quick Google indicates that they store data that is synced to the cloud, presumably on an auto setting.  Could an auto sync to the cloud have caused the report to stop functionning???  Anyone have any ideas? 

[Amal.]

Hi @Liann29501604zgoe 

I hope you're doing well despite the issues you're facing with the Access database and Acrobat application.

What is the workflow/steps you are doing to create these reports? if you could provide a small video recording of the steps you're taking to generate the reports and a screenshot of the error message, it would be beneficial in identifying the root cause of the problem.

Since you mentioned that the issue started after a recent update of the Acrobat application, it's possible that the update may have caused some compatibility issues. First, I suggest repairing the Acrobat installation from the help menu, rebooting the computer once, and then checking if the problem persists.

It's also worth checking for any missing or pending updates for MS Access, as this may resolve any compatibility issues between the Access database and the Acrobat application.

Let us know how it goes.

Regards

Amal

[Liann29501604zgoe]

Hi Amal,

I can't post video unfortunately as the data in the database contains confidential information.  The steps taken to create the report are simple selections from drop-down menus in MS Access to select the month, year and then a despatch reference number.  This pulls through all orders that are available to be despatched.  The user selects 'Generate Despatch Paperwork' and upon pressing the button the database runs a query to pull the data for the relevant orders into a form template within the database which is then automatically saved as a PDF in a specific save location within our shared network.  

You advise to repair the Acrobat installation - as far as I'm aware Acrobat is working perfectly fine in all other instances, it's just generating the PDF's from the database that we're having issues with. Therefore is there anything to repair?

[Liann29501604zgoe · Accepted solution]

Quick update on this - the problem was caused by the fact my Acrobat auto-updated to the 64-Bit version.  Our database is incompatible with 64-Bit, so we're reinstalling a 32-Bit version of Acrobat and adding the necessary Primary Keys to prevent the 64-Bit update.  Thank you for getting in touch Amal, very much appreciated 🙂