|
Subject:
|
Saving picture in Access
|
|
Posted By:
|
Jennyalex
|
Post Date:
|
8/11/2006 4:17:18 AM
|
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
|
|
Reply By:
|
anukagni
|
Reply Date:
|
8/11/2006 6:00:11 AM
|
you can get idea form this link
http://www.databasedev.co.uk/ or
http://www.download.com/Image-Albums-For-Microsoft-Access-/3000-2193_4-10563200.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
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
8/14/2006 10:09:43 AM
|
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
|
|
Reply By:
|
rgerald
|
Reply Date:
|
8/14/2006 11:14:19 AM
|
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
|
|
Reply By:
|
AccessMaster
|
Reply Date:
|
8/15/2006 12:09:33 AM
|
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
|
|
Reply By:
|
Jennyalex
|
Reply Date:
|
8/16/2006 7:55:13 AM
|
Thanx, i did work fine with a link to the picture.
/Jenny
|
