john471
Registered User.
- Local time
- Today, 11:23
- Joined
- Sep 10, 2004
- Messages
- 392
Hi All,
Having a bit of strange problem, not sure what else (if anything) to try.
I have a report based on a query. I can run the query just fine, it returns five records (at the moment). However, when I run the report, Access crashes... "Program Error ! MSACCESS.exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being created. OK"
Running Access 97 on Win2K SP4.
The report has no sub reports. (It is actually destined to be a sub-report, when I can get it to work).
I converted the db to Access2000 file format, running Access XP on the same machine, and the report then runs OK. Convert the db back to AC97 and then run it with AC97 (obviously), and the report crashes again. Open the original 97DB with XP (open, but not convert) and the report runs fine also.
Also tried (listed in no particular order) with no joy :-
/decompile
create new db, and import all objects
compact
repair
rebuild report from scratch (using wizard) *
useage of stern words
useage of coarse language
*after the wizard builds & saves report, and attempts to go to preview, Access crashes. Attempting to go into design view is no problem.
The following experiment did work; but it doesn't make for a viable on-going solution:-
1) Ran the underlying query as a MakeTable query.
2) Renamed the underlying query.
3) Renamed the new table to the previous name of the underlying query. (i.e. to effect it as the datasource for the report)
4) Run the report. Ran OK.
Of course the database NEEDS to run on AC97, so I can't just go with the XP version.
Any other suggestions on anything that might help ?
Regards
John.
Having a bit of strange problem, not sure what else (if anything) to try.
I have a report based on a query. I can run the query just fine, it returns five records (at the moment). However, when I run the report, Access crashes... "Program Error ! MSACCESS.exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being created. OK"
Running Access 97 on Win2K SP4.
The report has no sub reports. (It is actually destined to be a sub-report, when I can get it to work).
I converted the db to Access2000 file format, running Access XP on the same machine, and the report then runs OK. Convert the db back to AC97 and then run it with AC97 (obviously), and the report crashes again. Open the original 97DB with XP (open, but not convert) and the report runs fine also.
Also tried (listed in no particular order) with no joy :-
/decompile
create new db, and import all objects
compact
repair
rebuild report from scratch (using wizard) *
useage of stern words
useage of coarse language
*after the wizard builds & saves report, and attempts to go to preview, Access crashes. Attempting to go into design view is no problem.
The following experiment did work; but it doesn't make for a viable on-going solution:-
1) Ran the underlying query as a MakeTable query.
2) Renamed the underlying query.
3) Renamed the new table to the previous name of the underlying query. (i.e. to effect it as the datasource for the report)
4) Run the report. Ran OK.
Of course the database NEEDS to run on AC97, so I can't just go with the XP version.
Any other suggestions on anything that might help ?
Regards
John.
