MS 2000 Access application is crashing

pozzo

Registered User.
Local time
Today, 18:38
Joined
Jan 23, 2004
Messages
26
My MS 2000 Access application is crashing and returns a msg something like this: "Your Access application caused an error and Access must be closed"
This occurs only when I execute some forms; always the same forms cause the problem.
Somebody told me to copy the .mdb to another place in my HD and change the names of the forms.
I did it and it always works well!
Any good reason for that?
My app is not yet splited in FE and BE. Splitting would help?

Thanks a lot
 
You database may be corrupted.

You don't say what Operating system you are using. My database crashes virtually stopped when I upgraded to Windows XP. While developing a large database, I was crashing almosty hourly under Windows 98. Windows ME wasn't much better. Windows 2000 was somewhat better about eliminating crashing.

To correct a corrupted database - -

Make a list of all references in your current database. to do this select "Tools | References" via an open code module.

Create an empty database and then import all database objects. Note via the Options button on the Import screen you can also import Relationships, Manus and Toolbars, & Import/Exports Specs. After the import is complete, check that all your references have been selected. My DAO reference always gets dropped when importing all objects.

In my opinion and experience, windows memory management in pre Windows XP versions is the corruption problem.

Splitting your database may help, but I doubt it. There are other beneficial reasons for spliiting a database.
 

Users who are viewing this thread

Back
Top Bottom