Attachments

[Guest]

Is there any way that I can store an attachment, be it a Word attachment, or
a JPG attachment, to an Access Database??? We have a need where we are
identifying advertisements and storing them in an Access Database and we were
wondering if we could store the actual advertisement itself within an Access
Table.

If you could let me know if it's possible and point me in the right
direction to understand how to identify the column in the Access Database, we
would GREATLY appreciate it!

Thanks!

 

[John Vinson]

Is there any way that I can store an attachment, be it a Word attachment, or
a JPG attachment, to an Access Database??? We have a need where we are
identifying advertisements and storing them in an Access Database and we were
wondering if we could store the actual advertisement itself within an Access
Table.

If you could let me know if it's possible and point me in the right
direction to understand how to identify the column in the Access Database, we
would GREATLY appreciate it!

Thanks!

It's possible - store it in an OLE Object field - but the database
will bloat VERY rapidly, especially if you store images. It may be
better to store the files in a defined directory on disk, and store
the filename in a simple text field in Access; or to store a Hyperlink
to the file.

John W. Vinson[MVP]