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.'
It may not be a database that your application recognizes, or the file may be corrupt."
I guess the database should be corrupt.
if the size of your database is large,it looks easier to be corrupt.
So if possible,only save the path rather than the whole picture file in the database.