Large file linked to Pictures

[Guest]

I have large database that includes over 245,000 records of information. I
want to link each individual record to a picture of that record. How can I
do this in Access if possible?

 

[Dirk Goldgar]

I have large database that includes over 245,000 records of
information. I want to link each individual record to a picture of
that record. How can I do this in Access if possible?

The one thing you *don't* want to do, if you don't have to, is actually
store the pictures in the database. Instead, leave the pictures stored
in separate files on disk, and store the name of each picture file
(including the folder path, if that my vary) in a text field in your
table. On a form, use an unbound image control to display the picture
for the current record, by using the form's Current event setting the
image control's Picture property to the path to the picture file for
that record.