Access crash!!

[hin87_at_yahoo.com]

Hi

I'm having problem with my Access database. My application will crash
when I opened a form or a report (around 4-5 times before it will
crash)

Currently, I am the only user using this database. I am about 90%
complete, so I am the only one working on it. Here is how I structure
the files:

Front-End database: is an mdb file. Will be converting it to mde
after I finish with all the designs. This file contains reports,
queries, forms, and couple of tables.

Back-End database: is an mdb file. This only contains tables.

It's also crashing on different back-end database. Could it be my
front-end database causing it??

Thanks.

 

[John Vinson]

Hi

I'm having problem with my Access database. My application will crash
when I opened a form or a report (around 4-5 times before it will
crash)

Have you been Compacting regularly? You might also try Decompiling, or
creating a new, empty database and using File... Get External Data...
Import to import everything. See the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm for further ideas.

 

[Damien McBain]

Have you been Compacting regularly? You might also try Decompiling, or
creating a new, empty database and using File... Get External Data...
Import to import everything. See the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm for further ideas.

More likely to be a Windows shitting itself issue. Are you using 98 or ME?

 

[hin87_at_yahoo.com]

I am compacting it 3 times a day because the front-end database size
increases from size 5MB to 55 MB. But that is another problem I will
work on later.

I'm using Windows XP Pro and Office XP.

 

[John Vinson]

It's also crashing on different back-end database. Could it be my
front-end database causing it??

Likely. Did you try my suggestion of creating a new database and
importing everything? Do you have a lot of temp tables (which can
cause bloating and instability)?