Reply
 
Thread Tools Display Modes
  #1   Report Post  
kfschaefer
 
Posts: n/a
Default Automatic update of Embedded Access Query/Tables

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
  #2   Report Post  
Cindy Meister
 
Posts: n/a
Default

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The automatic date in letter template does not update J P Walsh Microsoft Word Help 2 May 10th 05 03:02 PM
Automatic Update with character styles Martinphilip Microsoft Word Help 2 May 3rd 05 04:42 PM
How do i update an access record inside microsft work? admincom Mailmerge 1 April 29th 05 08:45 PM
Access denied trying to open an embedded Word document EmbeddedTrouble Microsoft Word Help 1 April 20th 05 04:01 PM
Automatic update of fields in office XP Gadi Microsoft Word Help 2 February 28th 05 08:09 AM


All times are GMT +1. The time now is 08:30 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"