Images ok in forms but not ok in reports - need help please

[ab4access]

Hi!



I am new to the forum and hope I am posting in the correct directory.

I have an INVENTORY database for work that I created. It got up to about 1 GB in file size and it stopped letting me add images (about 5000 so far; 10000 more need to be added). I was loading them (attachments) directly into the database. Obviously that was the wrong thing to do.

So I went back into the database to delete the images / attachments columns in my tables as well as change my many forms and tons of reports to reflect the table's text field for the link on my hard drive to each image (using the control source via property sheet to view each image in both forms and reports). After about 800 links, the images do show up on the forms okay, but now only sporadically show up in reports; in any view mode and with printing. This is very frustrating.

What did I do wrong? Is this a MS glitch? A memory issue? How can this be fixed? I really do not want to break my database into many smaller databases; it's just not not logical.

Image type makes no difference whether it shows up or not; 99% jpg though.

Any suggestions, tips, tricks would be most appreciated.

Thanks in advance.

w7-64bit
2010-32bit

PS - the other downfall I seem to be having is that the image quality = very poor viewing on screen and very bad printing; though when I used the attachments for the images = crystal clear viewing and printing. I would say I'm a novice.

[June7]

I've never had an issue with images showing up in report. I have noticed the quality issue. Images will show great in Report View but weird in PrintPreview. Might be better with png, gif, bmp types.

[ab4access]

Thank you for the suggestion, but image type makes no difference whether it shows up or not. There are 15-20 thousand images; conversion is unfortunately not an option either. I have also discovered that some images will show in some reports and not others even if the same item is in more than one report.

[June7]

Can't replicate the issue. Would have to examine your db and report design.

[ab4access]

How does this happen?

[June7]

I don't know. Never encountered the issue.

[ab4access]

"Would have to examine your db and report design" - how would I get it to you w/o the rest of the world looking at it

[June7]

Why am I special? What's wrong with someone else seeing? Follow instructions at bottom of my post if you want to provide db.