Rerunning a script within Access 2

[thirty4d]

There are lots of Word files linked to the details in my database. I need to find a script within Access that would open the file(s), refreshes, saves and closes. Would mean that for the future I would be able to keep the Word documents updated just by rerunning the script.

I don't exactly know if this is going to be a problem because currently in our directory called J:/Eng/Lathe:
There are 16 subfolders and categorized by machine no., and each of these machine subfolders are at least 50 documents per folder. Not knowing exactly how many documents are affected if/when changes made to 1 or more records.

I haven't tried any solution or approach for I have no clue where to start.

Your suggestion is very much appreciated!

 

[HebieBug]

When you create the word documents are they a mail merge?
What sort of details are being changed?
Have not heard of anything in Access which will open up all your word documents and make alterations. DOes not sound impossible though. SOunds like it could be a case of writting VB code into Word Normal.DOT

 

[DaveSH]

thirty4d,

Could you clarify a couple of points?

Are you just trying to establish a link to the files in the various subdirrectories ? Or are you actually trying to extract data from the word files ?

Do you want to open the files in word from access ?

Do you want to view the document on your form in access ?

Are there fields in your table which are somehow representative of the subdirrectory structure ?

Just out of curiosity, what are the documents ( I have what sounds like a simalar application with CNC programs in a machine shop).
Dave
gallagherd@earthlink.net