Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 11th, 2006, 04:17 AM
Registered User
 
Join Date: Aug 2006
Location: Gothenburg, , Sweden.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Saving picture in Access

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
 
Old August 11th, 2006, 06:00 AM
Friend of Wrox
 
Join Date: Dec 2005
Location: CHENNAI, TAMILNADU, India.
Posts: 233
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to anukagni Send a message via Yahoo to anukagni
Default

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
 
Old August 14th, 2006, 10:09 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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
 
Old August 14th, 2006, 11:14 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Naperville, IL, USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old August 15th, 2006, 12:09 AM
Friend of Wrox
 
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old August 16th, 2006, 07:55 AM
Registered User
 
Join Date: Aug 2006
Location: Gothenburg, , Sweden.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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



/Jenny




Similar Threads
Thread Thread Starter Forum Replies Last Post
LOAD PICTURE FROM MS ACCESS zrtv VB Databases Basics 0 September 26th, 2007 05:14 AM
picture from vb-form to access kanoorani VB Databases Basics 0 May 31st, 2006 07:56 AM
How to save a picture in Microsoft Access Database Edward King Java Databases 0 January 4th, 2006 01:27 AM
Saving Picture file to specific Location sangeenobs VB How-To 0 December 13th, 2005 11:18 AM
saving picture from word to other folder DorisTan VB How-To 0 December 3rd, 2004 02:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.