Unable to write to an Access database table

[PriyankaaJ]

Hello Community,

      I am trying to automate an existing VBA macro to ingest daily and weekly product reports into an Access database table. For each day, there are an approximate 18K records that need to be input into the db table. In my current workflow I have all the records go to an Output tool that I have configured with an Ole DB connection and the output option set to "Append Existing", as follows:

When I run the workflow, I get the following error (the table and field names in the query statement are changed):

"Error: Output Data (47): DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.\3052 = -67634185
Insert into `Table`(`Field1`,`Field2`,`Field3`,`Field4`,`Field5`,`Field6`,`Field7`,`Field8`,`Field9`,`Field10`,`Field11`) Values (?,?,?,?,?,?,?,?,?,?,?)
"

Has anyone else come across such an issue? Is there a workaround/solution to this?

[Qiu]

@PriyankaaJ 
Not Database expert but maybe this helps.

https://docs.microsoft.com/en-us/office/troubleshoot/access/file-sharing-lock-count-exceeded