There are to main ways to employ images in an Access database. The first and simplest is to simply store the path to each picture. This can be a relative path (i.e. no dirve specification, only local folder and or simply the file name), or it can be an absolute path that includes a "fully qualified path" to the file. Once you've done this, you can make forms in access to display the image, but you'll have to do some light scripting. The second, more advanced way, is to actually embed the image into access. This is done through an OLE field type. OLE stands for object linking and embedding, but is just a fancy name for a binary field. Essentially, you can put anything in this field from images to executables. The problem with this is that you must make a script to extract the data. This can vary in complexity depending on the type of data, however the simplest way that will work for most anything is probably to stream the bits into a file and then open the file. However, using only access VBA scripting, this might prove inconvenient at best. My recommendation for a quick solution is the first option.
I hope this helps you. If you think I would be able to helo you any further, feel free to e-mail me at
TheTech@tampabay.rr.com
Team HeatWave's Strategy Programmer,
Bryan Jenks