Microsoft has finally gotten away from storing images in tables. You can see
that Northwind that ships with Access 2003 no longer has the employee
pictures in the Employee table.
The preferred method is to store file paths that point to the image files.
It will save a lot of bloat and make it easier to maintain.
Getting all the files from a folder into a table is a snap using the Dir()
function.
Inserting pictures into your database is definately not recommended as it
can lead to huge database 'bloating', the recommended method is to store your
pictures in a known location, and have an entry for each record that records
the pathname to the picture.
The whole process is too long to explain here, but check out the Access
pages at my website where you will see a tutorial on how to do this - there
is a little code involved, but there is also a sample database that you can
download and paste into your own application, so that should keep the work
down to much for you.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
