Forum Discussion
Solved
A Problem with attached images in Access, Windows 10, Office 365
I have built an ACCDB database for my comics. I haven't yet made the DB relational. I was mostly working on getting my records into the database, and the basic record, which is long but almost all r...
https://support.microsoft.com/en-us/office/access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c
If you put the pictures on a file system (as you should do for BLOBS > 4 KiB), be aware that NTFS has a soft ca. 10000 files limit per folder. (Hard limit is 4294967295 files per folder, but you can't open the folder in either Explorer or Access.)
Thomas Sowell — 'There are no solutions. There are only trade-offs.'
A handy solution has been found by using Excel to import the largest table. Of course, the PNG's were not imported as a column, but, more usefully, the names of the PNG's were imported as a text column. I saved the spreadsheet, made a new Access database, along with a Locations table that specifies the file path and physical location of a particular box (or notebook), and I can use Box ID as a foreign key for the Comics table to determine the location of a particular issue. At some point I'm going to have to write some VB script to display the JPG, but I need to get everything scanned first.