Automatic update of Embedded Access Query/Tables

K

kfschaefer

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
 
C

Cindy Meister

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
 

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

Top