Crashing All the Time

  • Thread starter Thread starter Ed Wiancko
  • Start date Start date
E

Ed Wiancko

My database keeps crashing (and recovering) when I do the
most mundane things. I try to add a picture to a button
on a form - crash every time. I do various other things
and have crashed 6 times in the last hour.

Can anyone give me some advice please?

Thanks,
Ed
 
My database keeps crashing (and recovering) when I do the
most mundane things. I try to add a picture to a button
on a form - crash every time. I do various other things
and have crashed 6 times in the last hour.

Can anyone give me some advice please?

Thanks,
Ed
Click to expand...

Crashed as in... corrupted? blue screen? ???

See http://www.granite.ab.ca/access/corruptmdbs.htm for a helpful FAQ
on database corruption.
 
It would help to know the Access version and OS. Access 2002 Crashed
constantly on my PIII 550 in Windows XP Pro, but hardly ever on a new P4
system. I ran the PIII in Windows 2000 compatibility mode and it stopped
crashing.
 
Access 2002
OS is Windows XP Tablet PC Edition Version 2002 SP1
It's a Acer Tablet PC with a 900mhz Centrino.
I've have one database that's a "project" w/SQL server
and it has no problems or crashes. Other Access DB's
have no crashes. Just this one and just for the last few
weeks or so has it become a real problem.
 
Access 2002
OS is Windows XP Tablet PC Edition Version 2002 SP1
It's a Acer Tablet PC with a 900mhz Centrino.
I've have one database that's a "project" w/SQL server
and it has no problems or crashes. Other Access DB's
have no crashes. Just this one and just for the last few
weeks or so has it become a real problem.
Click to expand...

You may have some uncured systems table corruption. If Compact and
Repair hasn't fixed it, try creating a brand-new empty database and
use File... Get External Data... Import to import everything (giving
you a new clean set of systems tables). Compile the database and then
compact and repair it.
 
Thanks for the suggestion. I tried it, (now I realize I
left out the "commpile" part - does it matter?) but I
still have the crashing problem. Any other suggestions?

Thanks much,
Ed
 
Thanks for the suggestion. I tried it, (now I realize I
left out the "commpile" part - does it matter?) but I
still have the crashing problem. Any other suggestions?

Thanks much,
Click to expand...

Yes; if your database does not compile correctly you're at risk. Open
the VBA editor by typing Ctrl-G or F11, and select Debug... Compile
<project>. Fix any compilation errors, then recompile and compact.

You still have not defined "Crashing".

What's happening? What messages do you get?
 
Hi John,

Thanks for your responses.
The message says: "Microsoft Access has encountered a
problem and needs to close. We are sorry for the
inconvenience." It warns about possibly loosing data and
it provides a check box for "Repair my open database and
restart Microsoft Access" It has a "Send Error Report"
button and a "Don't Send" button.

I usually press "Send..." and it then prompts me for a
name to save a "Backup Database As." About the same
moment, a small "Error Reporting" window shows the
progress of reporting the error - with a "Close" button
when it's done.

I haven't lost any data yet, but it is a terrible
annoyance. I wind up with 12-15 "backup" files after an
hour of development and you have to navigate back to
where you were everytime...

It doesn't happen in the same place everytime. It could
crash when I'm using the Form Wizard on a saved query.
Then, I get back in and run the same Form Wizard with the
same parameters and it completes fine - but then crashes
somewhere else later.

Oh, and I always compile the code - after every
modification.

The 'complete new db and import it all' did hold down the
crashes for a little bit, but they came right back same
as before.

Any other suggestions?

Thanks much,
Ed
 
Back
Top