Mail Merge with Word locks database

G

Guest

When users are using Word Mail merge it sometimes locks the shared database
so that other users can not open it. They recieve a 3734 error that the
database has been placed in a state by user.......and can not be opened.
This did not happen when they used A97 only since converting to A2003. They
use Word 2003 also. This happens quite often as they use this database
daily. The merge involves only one table named employees. I tried splitting
it and putting the frontend on their PC and leaving the backend on the
server. They complain about the slowness of this and also still need attach
to the backend for the merge. Any thoughts? I can not find any locks on the
forms or any controls on subforms referencing controls on the forms, I had
seen some articles that this could be a problem. It seems related to the
merge.
 
A

aaron.kempf

I'd reccomend using Access Data Projects instead of MDB format.
I've never had a locking problem I couldn't get around with ADP.. I
mean.. if worrst comes to worst; you can specify a locking hint; but
99% of the time it's not necessary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forms and mail merge 3
Mail Merge using ACCESS 3
SP3 and Mail Merge 1
Super Easy Mail Merge 3
Mail Merge with Word 3
Mail-Merge, Word, Access, and Address Labels 2
Frontend and backend database question 11
UK dates in database appearing as US dates in a mail merge document 2

Top