Discussion Locked

how to store an image file

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how can i store an image file (gif/jpg/tiff) in the database(ms-access), try to explain with example.

5 replies

by ebob

Insert --> Picture

For more details, may I recommend either MS Access' tolerable Help function, Technet, or any of several good references.

by sl-campbell

Try using an OLE-Object field, (define the field in the design mode of the table). Then you can insert a picture, or whatever, and with a double click call up the program associated with that file type in order to edit it. Use then an OLE Object container control on a form in order to show the picture.

However, I would suggest doing this only for an embedded/inserted objects and not a linked object. For a linked object just store the file path and name in the database and show it on the formusing the Object container control. This will simplify things if you want to programmically change the paths.

This discussion is closed to new replies.