Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-28-2019, 03:31 AM   #1
Blueskies
Newly Registered User
 
Join Date: Oct 2009
Posts: 31
Thanks: 8
Thanked 0 Times in 0 Posts
Blueskies is on a distinguished road
Corruption when linking from Word mail merge

Hi


I've been having an annoying issue lately when I link to an Access table from a Word mail merge document when the Access database is open and in 'design mode' (ie I may have edited a form recently).



I only seem to get this when the Access file is open on a Windows 10 PC (I usually use a Win 7 PC exclusively and that works without a hitch, whether the Access file is open at the time or not).


When I select the Access table via the Word Mail Merge Helper, it gives me an error about not being able to open the database and then the Access file corrupts.


I wouldn't be such a problem if I just got a 'can't connect' type message, but it actually corrupts the Access file so it won't open again without a repair.



I'll try to recreate the steps exactly and post it if needed, but I wondered if anyone else has seen this issue?


I'm using Office 2013, version: 15.0.5137.1000 on both Win 7 and Win 10 machines.



Cheers

Blueskies is offline   Reply With Quote
Old 06-28-2019, 08:24 AM   #2
moke123
Me.Dirty=True
 
moke123's Avatar
 
Join Date: Jan 2013
Location: Massachusetts
Posts: 722
Thanks: 2
Thanked 221 Times in 207 Posts
moke123 will become famous soon enough
Re: Corruption when linking from Word mail merge

Take a look at A.K.'s page....http://www.kallal.ca/wordmerge/page2.html

scroll down to "Don't let word attached to your running mdb file. "
moke123 is offline   Reply With Quote
Old 06-28-2019, 08:36 AM   #3
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 405
Thanks: 21
Thanked 88 Times in 87 Posts
mike60smart will become famous soon enough
Re: Corruption when linking from Word mail merge

Hi

Why not generate the document in Access as a Report?

mike60smart is online now   Reply With Quote
Old 07-15-2019, 02:00 AM   #4
Blueskies
Newly Registered User
 
Join Date: Oct 2009
Posts: 31
Thanks: 8
Thanked 0 Times in 0 Posts
Blueskies is on a distinguished road
Re: Corruption when linking from Word mail merge

Sorry for late reply on this guys - been on hols!

Unfortunately I'm supplied various documents by clients who like to use Word, so re-creating each one in Access is not feasible.

Thanks for the link - it's frustrating to have to export to excel or a text file just to be able to link the data though. You would not have thought this should be necessary just to avoid problems, but I will review the article.

Cheers

Blueskies is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge to Word nightflight Reports 0 03-22-2011 07:51 AM
Question Mail-Merge into MS Word.. DanJames General 1 10-02-2009 11:01 AM
[SOLVED] I need to merge an OLE field containing word docs into a word mail merge fearless_freep Modules & VBA 1 03-16-2007 02:57 AM
Help Req'd with Word Mail Merge!! andy_dyer Modules & VBA 2 11-17-2003 08:51 AM
Mail Merge with Word HELP CandyBoy Forms 1 10-12-2001 02:55 PM




All times are GMT -8. The time now is 05:48 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World