Runtime error 3211

Question

Using Access 2016, I create a report from a table.  If I display or print the report, everything works fine.  However, if I create a PDF (using docmd.outputto),

the PDF is created fine; but, the Record Source table remains locked after the report is closed (Runtime error 3211).  This means that the Access application must be closed and re-opened to create the next report. 

I have tried to use the table directly and via a query with the same results.  I am using Windows 10 Home and I've also tried Office 365 with the same results.

Thank you

Answer 1

Hi Scottgem, saw your this thread which was posted in Jun 16 -  

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother-mso_2010/your-query-does-not-include-the-specified/2cf37809-deab-457b-b75f-ff423dac53e0

can explain to me how to do this “Just use the Query Design mode. Add the 2 queries to the table grid and join then on OrderNumber. OrdernUmber should be in both queries. then add the columns you need to the query“. 

I have posted a similar thread here https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_windows8-mso_2016/ms-access-sql-help-need-two-join-2-tables/81991aef-ab78-4eea-919a-18a5474e622e?tm=1529113787197

Thank You.

Answer 2

I'll look at it this evening.

Answer 3

I stripped down the program to a single call to display and save the report.  It still demonstrates the problem,  The first time the report is called and saved - it all works.  However, when returning to the main form, the table remains locked.  This morning I tried turning off the virus check to see if that was locking up the file but I still had the same result.

Here is a link to the program:  https://1drv.ms/f/s!AnritxNsBZ6wgYwSiKyEr4vxDA77Ew

Thanks you

Answer 4

Some process has the table opened exclusively. I can't tell what based on what you have shown me. Nothing you have shown would do that. I use the DELETE/APPEND technique all the time and I've never encountered this problem.

The only other thing I can suggest is to upload a copy of the DB to Cloud storage and post a link and let me see what I can find.