Accessing MS Word documents from an acces database

[Guest]

HI, I am setting up a database which for a selected record should point to a
word file and then this files should be able to be called and displayed.

I.e. when the record in access is clicked on for the file named in the MS
ACCESS record, the MS WORD program should be launched and the file displayed.

Any tips or techniques on how to do this in a user friendly manner?

Speedy

 

[Arvin Meyer [MVP]]

I'd call the Word file separately from a hyperlink, or code following the
path stored in an Access database. Have a look at:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Arvin, thanks for your input.

I have however found a solution which is OK for my needs by using an
embedded OLE object. This allows the Word document to be displayed quite
well within an ACCESS form and to be edited with the original application
also.

Best regards,

Speedy

 

[Arvin Meyer [MVP]]

It does, but it will bloat your database quickly. If you have a lot of
documents, this may not be a good solution.

If there's a relative few documents (say less than a hundred small ones) OLE
objects work fine. If the documents need to be available to everyone
(including people without Access) you do not want to embed them, link them
instead. It will still cause bloat, but others will have the ability to use
the documents.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Indeed, I have only about 30 word files which are only one to 5 pages long so
it should be OK.

Do you have a reference which explains the differences between embedding
and linking with some examples? The Access book I use does not really
explain this properly.

Best regards,
Speedy