Automating picture import in Access

[alefer]

Hello everybody,

I realized an access database to store data concerning the results o
the tests of 100 detectors for high-energy nuclear physics.

I need to enter about 150 pictures and/or files for each detector.

The form is one, identical for all the detectors, and the names of th
pictures are always the same for every detector, the only change is th
name of the folder they are contained into.

Up to this moment, the only way I know to fill the database is t
insert every picture by hand by opening the form and right-clicking o
everyone of 150 Bound Object Frames.. but it seems to me a sort o
nightmare!

Is there a possibility to automate this task?

Thank you very much in advance, and best regards to everyone

Alessandr

 

[John Nurick]

Hi Alessandro,

See http://support.microsoft.com/?id=158941 for how to do it ... but
storing large numbers of images in OLE fields in an Access database is
usually not a good idea. They are stored very inefficiently, and unless
the images are very small you will not be able to store 15,000 of them
in an MDB file before reaching the 2GB maximum file size.

Instead, it's usually preferable to leave the images (and other files)
as files and just store their names and locations in the database. The
following links show some of the techniques:

http://www.mvps.org/access/forms/frm0030.htm
http://www.datastrat.com/DataStrat2.html
http://accdevel.tripod.com/imaging.htm