0

I have an Access database with linked tables to Excel spreadsheets I receive daily. (Rule in place to watch for these spreadsheets in my email and save off to OneDrive).

I have an Access macro to print PDF reports and save to SharePoint.

If I run the macro from Access, it runs fine. If I use a BAT file in the Task Scheduler, I get the "No Current Record" error.

This process worked for several years when I stored the database and spreadsheets in a shared network drive. But since moving the process to OneDrive, I get the above error.

I've search here but have not found an answer.

Tom402
  • 1
  • Where is your MS Access database located at? OneDrive? – Rene Mar 04 '20 at 19:06
  • Correct, the Access database and the Excel Spreadsheets are all contained in a folder within OneDrive. – Tom402 Mar 06 '20 at 13:59
  • won't work using OneDrive. I'd move back to using a shared network drive. Did you split your Access file in frontend and backend? – Rene Mar 09 '20 at 23:53

0 Answers0