Adding image to database 1

[aaabuhalime]

Hi,
I have a db for student, I want to add a picture for each student record, so every student record should include his/her picture, I added the filed picture in the database but I have read an article if I store the images in the table my DB will get very big and slow, so what I did is I stored all images in a folder on the network , I included the path to the images in the db, now I want to be be able to just add the picture through the the form, basically once I have a new student I can just take the picture and send it the folder, my question what is the best way to add the path/picture to the db through the form, and get the picture displayed on the form as well.

Any help will be appreciated.

Thanks

 

[MajP]

use a bound image control. If you bind the control to a field holding the path, then the image will render automatically.

 

[aaabuhalime]

I tried that it is working fine, I have an other question , is it possible to create a a browse button to browse the Images folder, and then what ever the user selected the path goes directly to the db table? if please how.

Thanks

 

[MajP]

You can use the file browse control. Here is an example

http://msaccesstips.com/2006/10/file-browser-in-msaccess/

A lot of us use the API code instead

http://access.mvps.org/access/api/api0001.htm

This seems to be a little less problematic

 

[aaabuhalime]

Thank you