Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   Saving Pictures in MSAccess Database (http://www.go4expert.com/forums/saving-pictures-msaccess-database-t5682/)

BrokenSyn 5Aug2007 10:35

Saving Pictures in MSAccess Database
 
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

thnx


___________
H0axility :D

shabbir 5Aug2007 21:21

Re: Saving Pictures in MSAccess Database
 
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 5Aug2007 21:35

Re: Saving Pictures in MSAccess Database
 
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 13Aug2007 11:20

Re: Saving Pictures in MSAccess Database
 
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.


All times are GMT +5.5. The time now is 01:57.