How to save an unlimited number of pictures in Access?

shaomin365

How to save an unlimited number of pictures in Access, and how can they all be displayed when opened?

stevevai

If this is the case, then your database design structure needs to be changed. It is best to use a special table to store these pictures, one record to save one picture, and each picture record has a parent code to follow other related records. For example, the record labeled 001 has 12 pictures. Then there is a parent class number in the picture table: parent_id=001, these pictures can be listed and displayed by querying the picture record with the number 001!

oldmouse

Agree upstairs, there is also a serial number field for the picture

shaomin365

Thank you, how do you display a variable number of pictures in the program?

hawknaga

The upstairs is completely nonsense, you have made the database redundant like you do.

I recently researched it, and the best solution is this:
You only need to add a field to save the physical address of the picture in the original database, put the physical address of these pictures in a field with a separator when uploading, and then call the split function to read out each physical address in an array. So your saving and reading problems are solved.