How do I do to browse a picture from a location and save it in the database and also, how do I do to show the picture by clicking a button...

/Jenny

you can get idea form this link

http://www.databasedev.co.uk/ or

http://www.download.com/Image-Albums...0563200.html
the above link just click download you will get an demo Ms Access database ...take it as an sample and try by yourself

agni

Just an FYI, I do not recommend saving the picture in the database. I would save the file name of the picture in your database and have Access show the picture based on a LINK to the picture.

Storing the picture in the database will make your database grow extremely large.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I concur with Greg. The size limit for an Access database is only 2GB. It would not take very many photo images (particularly high resolution ones) to blow past that limit.

Rand

check out http://www.utterangel.com and scroll down to "Picture in a Report" and "Picture in a Form". You can download the example databases

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Thanx, i did work fine with a link to the picture.



/Jenny