Link to home
Start Free TrialLog in
Avatar of mkyong
mkyong

asked on

How to VB<->picture<->Access?

what should i do if i want stores pictures like jpg or bmp in Access?

after, how do retrieve that pic with VB????
imgCook.Picture = LoadPicture(rs("imgPicture")) 'rs is a recordset
Avatar of hj2k3
hj2k3

it might be easier to store the images externally, and just have a string field in the database that contains the path to the file. not sure how to do it otherwise.

hope this helps
Avatar of mkyong

ASKER

yup, working images externally is easier, i done already, use the hyperlink.

i saw some Access databse use the OLE object to insert the picture, but dun know how to link with vb.

So, is that not possible stores picture in Access?  
ASKER CERTIFIED SOLUTION
Avatar of hj2k3
hj2k3

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mkyong

ASKER

Thanks hj2k3
no problem :-)