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?
 
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.
0
 
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
0
 
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
0
 
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
0
 
Jeffrey CoachmanMIS LiasonCommented:
testing this now
0
 
Engtech05Author Commented:
No problem, trying on this end as well.
0
 
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. :-)
0
 
Engtech05Author Commented:
If I find a way around this issue I will let you know Jeff.
0
 
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.