Automatic update of Embedded Access Query/Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kfschaefer - 10 Aug 2005 22:04 GMT

Is there a way to automatically update a word doc's embedded MS Access
tables, without clicking on each object and updating the field? Also, is
there a way to change the path of the embedded objects accross the board. I
have a doc that contains 100's of objects in which the path of the datasource
has changed mid-stream and I want to update the datasource so they are
consistent.--

Karen

Reply to this Message

Cindy Meister - 11 Aug 2005 07:57 GMT

Hi Karen

> Is there a way to automatically update a word doc's embedded MS Access
> tables, without clicking on each object and updating the field?
> Also, is

Ctrl+A, F9 will update all fields in one go. But no, there's no way to tell
Word to automatically have these fields update whenever a change is made in
the source. It would be possible to activate the option that updates all
fields when a document is opened, but

1. This could make opening the document prohibitively slow, with so many links

2. The newer releases have locked the option out (security issues) and you'd
have to set a Registry key to re-enable it (KB article:
http://support.microsoft.com?kbid=330079 )

> there a way to change the path of the embedded objects accross the board. I
> have a doc that contains 100's of objects in which the path of the datasource
> has changed mid-stream and I want to update the datasource so they are
> consistent.--

Alt+F9 will show all the field codes behind these links (DATABASE fields).
With Find/Replace you can change the file paths fairly easily :-)

-- Cindy

Reply to this Message