Application Crashes

[Kevin199]

I have an application that fires from a form button. It can take a long time
to run a report. The app is all on one pc, no network. Depending on what
information is requested the report can be done in 10 minutes or up to 2
hours (calculated). My problem is when I am running a report that takes a
half hour or so it crashes and I get the message : "Cannot open database 'one
of my queries'. It may not be a database that your application recognizes,
or the file may be corrupt." After it crashes if I try it again I get the
message immediately. After repairing the db it works fine on short time runs
and crashes after about a half hour again. any suggestions and solutions
would be much appreciated.

 

[Gina Whipp]

Kevin,

Not alot to go on... but from what you said if the report takes that much
to run I have to wonder about the table set-up. What could this report be
running that causes the database to crash? How big does it get while
running this report? How many tables and/or queries does it take to run
this report? Are you running alot of action queries?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Kevin199]

Gina,
Thanks for the help. The answer is yes. I have way too many tables and
action queries. It started out as a quick and dirty app and now is a
monster. I initially thought my screen saver kicked in and messed it up but
that is not the case. I am pretty sure the data getting crunched is not the
prob because it crashes the same on different data. Do you think it could be
a memory problem causing it to corruptplode after long runs? If so what
could I do, short of reworking my code?

 

[Gina Whipp]

Kevin,

I concur it is not the data, nor a memory problem, nor a code problem.
Unfortunately, you have found the problem of what will happen if your
foundation (tables) are not stable. If you provide tables and fields we can
help. It really sounds like your tables need to be normalized...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


http://www.databasedev.co.uk/table-of-contents.html

Failing to fix the foundation will eventually make the house crumble.
Picture this... my house, all 2,000 square feet, built on a foundation for
a 1,000 square foot house? It may stand for a day, a year but eventually
I'll be homeless! So befroe you become databaseless let's work on those
tables!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm