Need advice on Word Automation from Access

[Lauren Wilson]

Hi folks,

There appears to be a way to store a Word Document in an OLE Object
field of an A2K table. Is that true?

If so, how can I allow the user to open such files by spawning an
instance of Word FROM inside the Access form so that the document
saved in the current record opens for editing.

All responses appreciated.

--Thanks

[Lynn A.]

I would use a hyperlink field instead. The filename is stored and the
user just has to click it to start word.

Lynn

Lauren Wilson <XX***@XXXXX.XXX> wrote in message news:<h4********************************@4ax.com>. ..

Hi folks,

There appears to be a way to store a Word Document in an OLE Object
field of an A2K table. Is that true?

If so, how can I allow the user to open such files by spawning an
instance of Word FROM inside the Access form so that the document
saved in the current record opens for editing.

All responses appreciated.

--Thanks

[Pieter Linden]

Lauren Wilson <XX***@XXXXX.XXX> wrote in message news:<h4********************************@4ax.com>. ..

Hi folks,

There appears to be a way to store a Word Document in an OLE Object
field of an A2K table. Is that true?

If so, how can I allow the user to open such files by spawning an
instance of Word FROM inside the Access form so that the document
saved in the current record opens for editing.

All responses appreciated.

--Thanks

I wouldn't store the file as an OLE object. Your database is going to
BLOAT and FAST. Store the absolute path to the file and then use late
binding to open the file. Just do a quick automation. Use
fIsAppRunning and then grab some of the automation samples from
www.mvps.org/access