Link to home
Start Free TrialLog in
Avatar of jasonstele
jasonstele

asked on

Access-Word 2016 mail merge exclusive lock issue

I have a 2016 MS Access - Word application.  The database has the front-end code stored in an Access db on each user's c-drive, and that front-end db links to the actual data which is stored on a fileserver.  This application supports MS Word 2016 mail merges.  These mail merges all have one datasource which is driven by a single temp table that is created on the user's local db copy.  If that single user wants to open more than one merge letter, they receive a run-time 3009 stating that 'you tried to lock table 'blah blah' while opening it, but the table cannot be locked because it is currently in use.  Wait a moment, and then try the operation again."

From what I can tell, the first merge letter is using an exclusive lock on the MS access temp table datasource.  Is it possible that the merge letter cannot use an exclusive lock allowing the single user to open multiple merge letters that are all based on the same temp table?

Thank you in advance!  -Jason
Avatar of Daniel Pineault
Daniel Pineault

I highly recommend you implement Albert Kallal's Super Easy Word Merge found at http://www.kallal.ca/msaccess/msaccess.html.  The beauty here is that instead of locking tables ... it generate a text file and the Word Merge binds to the text file leaving the database unimpacted.
Avatar of jasonstele

ASKER

Thx, I have approximately 900 merge letters that I’m hoping to avoid changing the data source.  I’ll have a look
You could query the table on the BE and create a temp table based on the filtered input on the BE to use it for the Mail Merge..so the locking period would be kept to minimum
Thanks for your input.  I’d appreciate additional clarification though.  I’m currently querying the BE data and creating a temp table on the FE.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.