Linking 20,000 images

[pbouk]

Hi there,
I'm trying to redesign a database that consists of approx 20,000 images along with information about each one.
I'm using Access 2010 and I'm wondering if anyone has any advice about the best way to store and display the images. Currently they are attached in a table, but this has made the database very bloated.

We have a form designed where you can click through each image record with its corresponding info.



Would it be better to externally link each record to each individual image? Of course, this would be very time consuming to do! Is there some kind of code that could assist me?
I'm not very experienced with code, but I'm prepared to learn.

Thanks.

[ItsMe]

I suggest you export the images and save the path to a new field in the same table. This link here might get you started.
https://www.accessforums.net/import-...der-25651.html