Word doc and excel docs

[Mat]

I have posted this is the wrong place so forgive me.

I have a database with a table of job records which
listed job no, customer information etc. I would like to
attach if possible a number of word docs and excel docs
to these records. So people could access them from the
database centrally. I know that there are a number of
software products that allow you to attach emails, word
and excel documents. I wondered if it was possible to
replicate this with Access 2000.

Can anybody help

Thanks In advance

Matt

 

[chas]

Hi Matt,

Access has a field type of OLE Object that can be used to
store Word/Excel documents in the table. It is possible
to either embedd the document (make a copy of it) in the
table, or you can link to the original so any changes to
the document are reflected in Access.

Once you have added the field to the Table and to your
Form, in Form view place the cursor into the field and
select Insert>Object (or right-click. You will get a
dialog box with the oportunity to choose 'create from
file'. Locate the relevant document, select it and make
sure you choose 'Link'.

Be aware that embedding documents can 'bloat' your
database.

hth

chas