Storing a file with an access record

[Robert Anzalone]

Can someone point me in the direction of some good documentation showing how
a user might store a text or image file in an access record?

 

[Marcia]

Hi Robert

The way i do that is to create a field in a table and use
the OLE Object under the data type, then go to your table
and then select - Insert - Object and then select the type
of Object you want - from the list - I did it playing
arround and I am still new to Access.

Good luck and let me know if this helps you.

Thanks MARCIA

 

[John Vinson]

Can someone point me in the direction of some good documentation showing how
a user might store a text or image file in an access record?

Access is VERY inefficient at storing images - it converts (say) a
..jpg file to a much bigger Bitmap and stores BOTH. Typically one
should store just the path and filename in a text field, or you can
use a Hyperlink.