By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

Need advice on Word Automation from Access

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.