Application Crashes

[Kevin199]

I have an application that fires from a form button. 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
on longer runs. Any suggestions and solutions would be much appreciated.

 

[M Skabialka]

Make a backup copy, then split your database into front and back end as soon
as possible! It sounds as though something is corrupt, and if you don't
save it now you could lose it all! In my experience I have found that the
table data is less likely to corrupt than the form, reports and queries,
etc. After the split, decompile, compact and recompile each part (backups
first!!).

And yes, you can have a 2 part database on a single machine.

I have had slow reports, but half an hour? Are you by any chance writing
progress to a form, e.g. number of records processed? This will slow you
down immensely. If so, just write to the form every 100th or 1000th record
instead.

Mich

 

[Jerry Whittle]

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

You may have a corrupt database.

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp