Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Save image to Access database

Status
Not open for further replies.

skalet

Technical User
Mar 31, 2002
1
SE
Hello,

I have a path to an image (gif, jpg and/or bmp) and want to save the image in question to my Access database by using VBA code.

Do I need to open the image first, read the binary content and then manually save the binary data to the OLE-field in my Access database or can I just pass the path to the OLE-field in the database and it will know what to do with it (put the image's content in the database)?

It is so simple to extract an image from a database (using recordsets), so it seems like it should be at least as simple to write an image to the database.

I want to have the image in the database, so please don't start a discussion about linking vs. non-linking of images.

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top