Reports are causing Access to crash

speakers_86

Registered User.
Local time
Today, 03:22
Joined
May 17, 2007
Messages
1,919
I have a lot of reports that all have the same subreport in the header. Is this what is causing access to crash? Should I have many different copies of the subreport so my reports do not share the same subreport object?
 
I do exactly the same and don't experience crashes, generally I've do something that affects the subReport ie I've mucked up.

Simon
 
Any other ideas? It seems the reports were working very slowely (taking forever to load), and I just thought it was the computer. But all of a sudden all reports cause a crash.

I haven't really done any troubleshooting yet, but I did try to delete the subreport and then open the report (working with a back-up) and it did dramatically impove performance. That doesn't make any sense to me, as the subreport is simple. It is based on either a table or query (don't remember) of tblCompanyInfo. This subreport serves as a header to make the reports look officlai.

Another approach I took with many of my reports is that the header and footer are actually the main report, and the actual information in the report (ie, the details) are a subreport. This worked for me when the info was linked, but for some of the reports were there was no link between the details and the header, I had to take the other approach. Regardless of the appraoch, it seems to be giving me problems.
 
Are the tables linked to a Backend. I would use a Subreport in the Header from tblCompanyInfo and the Detail without a subreport. You could put Company into all your tables and create a Parent / Child relationship on the Subreport.

Simon
 
The tables are not in a backend, because I am not done development. I did launch an early version at my companies office. It works, but the reports are generated pretty slowely.
 
What volumes or data are we taking about. Large files? Are Union Joins used? What happens if you create a report with just the subreport from tblCompanyinfo. Check the speed of a query on tblCompanyInfo. How many records in tblCompanyInfo or the qryCompanyInfo?

You could also try:

Backup First
Splitting the databases (locally) taking out all the tables
Create a backend database with all the tables
Create a frontend database with evertything else

Then compile the frontend. Then try the mde or accmde

Simon
 
So it looks like I am back to this issue. Heres whats going on.

When a report is opened, it takes about 10-30 seconds to open. The first attempt takes the longest, and it opens faster and faster at every attempt to open it, unless the data or parameters change, then your back to waiting for it to open.

This happens with a split version and a version that is not split. Don't know whats going on, but this sucks because I am done development. Please help!


edit: I just found out that on the fifth try to open, it is back to square one, it takes forever again. Does access start clearing its memory after 5 new windows are opened? This also seems to happen if the focus leaves access. If you are on the second try to open, it should open fairly quick, unless you loose focus of access. When you try to open it, it takes a while. I don't get this!
 
Last edited:
It does seem that the SubReport is misbehaving. How many records in tblcompanyinfo - I'm assuming - one. Whats in the subReport? Is there ant relationship between the report and subReport?

I know I maybe repeating myself but lets kick this into touch!

Simon
 
Only one record in tblCompanyInfo. The subreport is based on the table. The table only has one autonumber field, a few text fields, and one attachment field (A07 feature). No relationship between the sub and the report.

Now that I listed the fields out like that, I wonder if the attachment is causing the issue. There is only one attachment to that field, its the company logo. I'll try to get rid of that and see if that helps.


edit: I opened some reports on a different computer, and the reports are working just fine. I'll go back to the office, which is where I was having issues, and see if removing the attachment helps.
 
Last edited:
You still use the Company logo but perhaps in a bound image field.

Simon
 
That is what I am thinknig. Might work out better that way anyway. I'll let you know what happens as soon as I try it.
 
I took one of the reports and deleted everything, including the vba, and it still opens slowely.
 
I just created a new report based on a simple query (with no subreports) and it opens slowely too. That makes me feel a little better, because that means my reports should be okay, but the problem is still a mistery.

I have tried exporting everything to another db, but that made no difference.
 
I read it, but it did not seem to offer any advice that could help me, at least not with this particular problem. I am open to suggestions though.
 
I read it, but it did not seem to offer any advice that could help me, at least not with this particular problem. I am open to suggestions though.

Well, you were saying it was slow, regardless. So, I thought perhaps some modifications might be necessary - not necessarily for the original issue though but for the slowness issue.
 
I saw this post and was going to ask if you were moving between versions....03 to 07.... But I see you said you had an attachment field so I assume only 07... I had this same problem on a project.... But I don't think I ever figured it out. I think on mine the reports were being corrupted when I made changes. I finally just kept a backup before making any changes to I always had a good report to import if the current became corrupted. I finally started making all changes in 07 (the client was using 03) and it seemed to hold up. Well, at least I know I'm not alone :) Wonder if we have an oddball bug..... good luck.
 
you say it works fine in another computer - what's different about that computer and yours? are they different access versions?

are you subreports based on "NOT IN" queries?
 

Users who are viewing this thread

Back
Top Bottom