Database Crashes in Development

[dawnecia]

I am creating a database in Acc03 SP3 and the database keeps crashing. I
could be putting a button on a from or creating a report or form or query.
There is no logic to when or why it is crashing it just does. I am
recreating the database again for probably the 10th time. I have repaired
Office, installed updates, re-installed access, check for viruses. Do you
have any suggestions?

 

[Tony Toews [MVP]]

I am creating a database in Acc03 SP3 and the database keeps crashing. I
could be putting a button on a from or creating a report or form or query.
There is no logic to when or why it is crashing it just does. I am
recreating the database again for probably the 10th time. I have repaired
Office, installed updates, re-installed access, check for viruses.

Try importing all objects into a new MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[dawnecia]

I've tried that a couple of times and it still crashes. I am thinking about
removing Office then reinstalling up to SP2 to see if this solves the
problem. I am not sure what else to do. At the point the database is
crashing there is not a lot of code or objects created as yet.

 

[Allen Browne]

Tony's suggestion is often useful but there are some other things you may
need to do as well, such as decompiling. In some stubborn cases where it is
a particular form that is crashing, you may need to recreate that form.

Once a well-designed Access database is developed, my experience is that
corruption is quite rare. On a stable network with stable power, reliable
computers, and users who don't just crash out of Access, it can go for years
without corrupting. But during development, when everything is changing,
corruption is much more common.

Here's some guidelines on how to prevent corruption - in general, and
specifically during development:
http://allenbrowne.com/ser-25.html