I want to keep track of letters sent to clients on my VB 5.0 Access 7.0
database.

Is the best way to store each document as an OLE field or to store the dos
path in the dB. If it is the latter how can I link Word with VB so that when
the user wishes to save a document it is stored on the database for easy
retrieval.

I imagine this problem must of been dealt with before.

Many thanks for any help or suggestions.

Yours gratefully,

Niall.

It is more efficient to store the path & filename of the document in the
database. You would need to create a couple of macros in Word to save and
retrieve the document info from your Access table. If you are using Word 97
all this will be alot easier, since it uses VBA instead of Wordbasic. You
could put the macros in a global template that is loaded with Word
automatically, and then let the user access them from the menu or toolbar. I
just finished a project that did a lot of this sort of thing, using Word 97.
You don't need to link Word to VB because VB is now built into the product.