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.'
Well Access and Images is a tough case
For start you could check my article on working with Images and Access :
https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html
(for the time being 32bit)
Other than that since it seems you quickly filling the space two options :
1. If its single user you could switch your BE to Sqlite
2. If its going to be multi user then Firebird is your friend
I had a case with 1000s of images populating a MsFlexGrid without issues with Access as FE and Firebird as BE
For start you could check my article on working with Images and Access :
https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html
(for the time being 32bit)
Other than that since it seems you quickly filling the space two options :
1. If its single user you could switch your BE to Sqlite
2. If its going to be multi user then Firebird is your friend
I had a case with 1000s of images populating a MsFlexGrid without issues with Access as FE and Firebird as BE