Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We are using an Access97 database to merge with Word 2000 but the process locks the whole database. The Access 97 databse is read only. Does anyone know what's happening?
3 replies
by mslizny
The database is locked when you are using it in a Word merge so that no records change until the merge is done. This is done because any sorts or record numbers in the merge could change if the information in the database were able to be modified while the merge is taking place.
by mslizny
Microsoft Access uses "optimistic locking" to protect records that might be accessed by multiple users. This can be modified. More information about this is in Microsoft Knowledge Base articles Q225926, Q209763 and Q275561 (see "Record-Level Locking")at http://support.microsoft.com/directory/
You might also want to consider using the Office Links to "Publish It in Word", which would convert the table or query you are using in the merge to a Word table. The merge can then be done using theWord table and the Access database will be available to other users.
by kevrizz
When we used the Access97 database with Word 97, there was no lock up. Is it something to do with Word 2000?
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
Question Unanswered
Best Low-Latency VPN Protocols for Competitive Mobile and Online Gaming
0 helpful
0 replies
0 helpful
5 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies