Discussion Locked

images in a database

0 helpful

6 replies

by mcaeronen Mar 23, 2001 last reply Mar 29, 2001

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to provide a database of actual images [as oposed to a hyperlink- ole - etc]
in either excell or access 97

6 replies

You can store all types of images (bmp,jpeg, etc) in an Access table. Use the field type of OLE Object.

Good Luck

Neal Martinelli

I thought the response I posted a few days ago accepted this response plus awarded the points to Neal Martinelli
Hope this fixes it now

Access 2.0, Access 95, Access 97, and Access 2000 = "OLE" Data Type can store any graphic file type as a variable from record to record.

You can't use OLE as a Key or sort field however.

please give points also to this subscriber even though I had already accepted a previous answer and closed the question

wil test and be back again later prob sunday
thanks
Mike

This question was closed by the author

This discussion is closed to new replies.