Linked Table Issues

With the help of Expert Jeff Coachman aka boag2000, I was able to get the images I needed to display in the DB. Now I cannot get a report to run with the images. I am not sure if there are too many images or what might be the problem. I have tried everything I know to get the report to run. I can view it with 10 records but if I try with a full report, I get the report but no images.

One table contains the linked images as well as other information. Should I split the tables where the linked images in a separate table?
All help is much appreciated in advance.
Engtech05Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
The sample I typically post contains a report that uses the images...
On the Format event of the Detail section, the image is displayed (if one exists)
(attached)

One thing to remember is that the report need to be opened in "Print Preview" explicitly for the images to fully "Render".

If this does not help, then post a  simple copy of the DB...
Access-BasicLinkFormReportImages.mdb
Engtech05Author Commented:
I do open it in 'print preview' and it takes a long time to complete the formatting.
I will send a simple copy of the DB in a min.
Engtech05Author Commented:
Ok, this is weird, I was setting up the simple db to send you and everything works. I wonder if it has to do with the amount of images. I am up to 215 right now and the sample db has 23.
Any ideas
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Engtech05Author Commented:
I didn't want to upload 25 images, can you try this out to see if it works for you. I keep wondering if it is the amount of images that is the problem. If so, is there a work around of something different to do.
Asset-Locator-Test.accdb
Jeffrey CoachmanMIS LiasonCommented:
testing this now
Engtech05Author Commented:
No problem, trying on this end as well.
Jeffrey CoachmanMIS LiasonCommented:
Ok,
I created a real-world scenario of putting the images on a server.
250 images with an average size of about 1mb.

At about 200 images (Records) the report just wont generate at all.

At about 100 images the report will generate, but I could only view about half the pages before the code failed again. (with some images not appearing, as you stated)

Perhaps this could be improved by:
Using smaller images (or lowering the resolution on the existing images)
Installing more Ram (I have 3GB installed)
Getting a better Video card.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Engtech05Author Commented:
Thank you for trying Jeff, This going to be a pain. I think when I generate reports I will only show images that are like Items, I should be able to get away with that. I will also try to generate thumbnail images at report time. I have 6 gb installed and a gamer video card as well.
Again thanks for the help, I thought I was loosing my mind. :-)
Engtech05Author Commented:
If I find a way around this issue I will let you know Jeff.
Jeffrey CoachmanMIS LiasonCommented:
You could try going back to "Attached" files.
But the same issues I mentioned in the previous Q would still apply.
However, if you can live with those issues, then that may be the way to go.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.