As you described, put the image file into a separate folder, and store the
path and file name in one or two text fields.

You'll be viewing the image in forms and reports, not a query. Previous
posts have covered the details on how to do this.

Hope that helps

Fred


"compmail" wrote:

I have database cards with both text and drawings. In Access 2003 I want to
set up a data base with some fields that I name and enter the data myself,
then in another field I want to insert a scan of the manual data cards. Do I
scan these and store them as a separate document. In the database field what
do I type to create a parth to that document. Ideally when I do a table
query I want it to be able to bring up the record and to show the scanned
data card relating to the information in the fields I typed.
Or do I insert the scanned document direct into the data field and how?

Thanks for any help
--
compmail always learning