danielpilon22
New member
- Local time
- Today, 06:57
- Joined
- Jul 5, 2017
- Messages
- 2
Hi everyone !
I built a database for all my board games, and with 178 games and over 400 images total, I just can't create a report of all the records without Access 2013 not responding and then crashing. We're talking about an image folder weighing about 95 Mb overall (about 215 Kb per file, on average), so maybe that's a lot to swallow for poor Access.
The end game for me would be to be able to print a whole inventory of my games within one click, with all the visual stuff I put in (photo of the box, photo of a game being played, level of difficulty, level of competitivity, appreciation from 1 to 5 stars, etc.). I'd rather not trim it down, because it's much more appealing and colorful with all the clipart added in. Maybe I could turn some images off while formatting the report ? Make it "print only" ?
The database itself weighs less than 10 Mb. In other words, those images are not embedded directly into the Access file itself, as it tends to bloat the database: each file path ("F:\folder\subfolder\access files", for instance) is written down in a field, in my main table. With a bit of VBA coding, I can link the path to the corresponding image frame, so that every time, the database comes looking for the right image path to display the right image (i.e., if you open the "Risk" record, then the "Risk" game box picture would appear). For a smaller database, it's fine, but now, it just crashes Access while formatting the report. The form preview works pretty fine, but I guess that loading just a single page at a time helps.
This may not be the smartest way around for purists, since there is a lot of redundant code hanging about (Access' archenemy of sorts), since most of the files do carry the same path over and over again (in my previous example, "F:\folder\subfolder\access files" repeats itself for every single image I put in). I tried to edit out the repetitive part out with some intricate query or VBA coding in order to help Access filling in the repetitive bits without hardcoding them into a table, but I only ended up in more misery.
Note: this is only for my personal use on my sole PC, so there is no fancy server architecture behind all this. I tried compressing files via an image editor, changing the file extensions to BMP, compressing the images via Access (which did a ludicrous job, to be polite). Taking every picture off the report is sadly the only way to get the report working without any crashes... but where is the fun in that ?
Would there be an easier, more efficient way (a query, a better table structure, some VBA miracle perhaps ?) to load images into a report so it can work out again, even though there is a massive amount of images to display ? Or have I gone too far with my ambitions ?
(As of now, the only workaround I found was to create an individual report for a single game via VBA coding: according to the opened record (in the Form), the macro translates the details into a single-page report for this particular game. It does the trick for every new game I add, but not for the whole inventory.)
Thanks in advance,
Daniel Pilon.
I built a database for all my board games, and with 178 games and over 400 images total, I just can't create a report of all the records without Access 2013 not responding and then crashing. We're talking about an image folder weighing about 95 Mb overall (about 215 Kb per file, on average), so maybe that's a lot to swallow for poor Access.
The end game for me would be to be able to print a whole inventory of my games within one click, with all the visual stuff I put in (photo of the box, photo of a game being played, level of difficulty, level of competitivity, appreciation from 1 to 5 stars, etc.). I'd rather not trim it down, because it's much more appealing and colorful with all the clipart added in. Maybe I could turn some images off while formatting the report ? Make it "print only" ?
The database itself weighs less than 10 Mb. In other words, those images are not embedded directly into the Access file itself, as it tends to bloat the database: each file path ("F:\folder\subfolder\access files", for instance) is written down in a field, in my main table. With a bit of VBA coding, I can link the path to the corresponding image frame, so that every time, the database comes looking for the right image path to display the right image (i.e., if you open the "Risk" record, then the "Risk" game box picture would appear). For a smaller database, it's fine, but now, it just crashes Access while formatting the report. The form preview works pretty fine, but I guess that loading just a single page at a time helps.
This may not be the smartest way around for purists, since there is a lot of redundant code hanging about (Access' archenemy of sorts), since most of the files do carry the same path over and over again (in my previous example, "F:\folder\subfolder\access files" repeats itself for every single image I put in). I tried to edit out the repetitive part out with some intricate query or VBA coding in order to help Access filling in the repetitive bits without hardcoding them into a table, but I only ended up in more misery.
Note: this is only for my personal use on my sole PC, so there is no fancy server architecture behind all this. I tried compressing files via an image editor, changing the file extensions to BMP, compressing the images via Access (which did a ludicrous job, to be polite). Taking every picture off the report is sadly the only way to get the report working without any crashes... but where is the fun in that ?
Would there be an easier, more efficient way (a query, a better table structure, some VBA miracle perhaps ?) to load images into a report so it can work out again, even though there is a massive amount of images to display ? Or have I gone too far with my ambitions ?
(As of now, the only workaround I found was to create an individual report for a single game via VBA coding: according to the opened record (in the Form), the macro translates the details into a single-page report for this particular game. It does the trick for every new game I add, but not for the whole inventory.)
Thanks in advance,
Daniel Pilon.