Saving Pictures in MSAccess Database

BrokenSyn's Avatar
Light Poster
anyone got a codes for Browsing Pictures in Files to Visual Basic 6 and Store it or Save it in Microsoft Access Database. And then Retrive it in Viusal Basic 6.0


shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
I have done that some time back but could not get the hands on the code but I wil try to recall.

I had some binary data fields in the database and then used to read the file in the variant and then dump that data into the database.

When retrieveing I just copied the data into the temp file and showed it in the picture box.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Also I just realized you are using the signature in the post but you can use it by visiting the My Go4Expert link In case you did not know that.
jwshepherd's Avatar, Join Date: Aug 2007
Team Leader
depending on how many you are planning to store it actually makes more sense to just store the path to the files. once an Access database gets larger than 1Gb it starts getting slow and at 2GB it may become corrupted.