[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Linked Table Issues

Posted on 2011-10-06
10
Medium Priority
?
262 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:Engtech05
  • 6
  • 4
10 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36925945
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
 

Author Comment

by:Engtech05
ID: 36926310
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
 

Author Comment

by:Engtech05
ID: 36926616
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:Engtech05
ID: 36926960
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36931539
testing this now
0
 

Author Comment

by:Engtech05
ID: 36931558
No problem, trying on this end as well.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 36933301
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
 

Author Comment

by:Engtech05
ID: 36933321
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
 

Author Closing Comment

by:Engtech05
ID: 36933474
If I find a way around this issue I will let you know Jeff.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36937438
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question