Importing emails, faxes and documents

[Ann Shaw]

Hi to all the experts out there!

I am wondering is it possible to import documents into my
database.

Eg of my data:

I have a straightforward table containing information
about my foreign students attending the college. If I
need to send a letter to them in Word or I receive or send
an email in Outlook, I would like to store these relative
documents somewhere in my database in Access so that I
have everything in the one place.

Can you help???

Many thanks

Ann

 

[John Nurick]

Hi Ann,

Access can store documents in databases: you use an OLE field in the
table, and on the form put an ObjectFrame bound to that field. But it's
a bit clunky and, more importantly, causes the size of the database to
"bloat" beyond reason.

Usually it's better to leave the documents as files on disk, and just
store their locations in the database. See the DocMgr sample database at
http://www.datastrat.com/DataStrat2.html for an example of how to do it.