keep getting error message pop-up windows

[Associates]

Hi,

I wonder if anyone might be able to help me out. I keep on getting this
error message from windows in the pop-up dialog box that shuts the database
off and created a backup copy and then ask if i want to send the error to
microsoft. This happens when trying to add a button onto the form to increase
more functionalities to the database. Apart from that, it works fine.

Initially i thought it could be to do with the size of the database but it's
only 10 Meg. Could it be anything else that trigger this problem?

BTW, this is Access 03.

Thank you in advance

 

[Tom Wickerath]

This type of error sounds like a GPF (General Protection Fault). Try using
the undocumented /decompile switch. If you only have one version of Access
installed, then click on Start | Run and enter the following:

msaccess /decompile

The next database you open will have it's "P" code (Pseudocode, a
semi-compiled version of the canocial text that you can see and edit)
removed. Open the database with the Shift key held down the entire time, to
prevent any startup code from running. As soon as the database is open,
verify that you have deselected the Name Autocorrect options:

Tools | Options ---> General Tab
Disable Name Autocorrect.

Then compact your database:

Tools | Database Utilities | Compact and repair database

again holding down the Shift key the entire time. When the database
re-opens, open any code module and click on:

Debug | Compile ProjectName

where ProjectName is the name of your VBA project. While you are in the VBA
Editor, it's a good idea to remove the default Compile On Demand options:

Tools | Options... > General Tab
---> Deselect the Compile On Demand options.

On the Editor tab, ensure that you have the "Require Variable Declaration"
option selected. This is not selected by default, in new installations of
Office. After making these two changes, try compiling your code again.
Correct any compile errors that may result.

If you happen to have more than one version of Access installed, then you
need to enter the full path, surrounded in quotes if the path includes
spaces. You can also create a new decompile shortcut with something like the
following in the target of the shortcut:

"C:\Program Files\Microsoft Office 2003\OFFICE11\MSACCESS.EXE" /decompile

See if doing this much helps you out. If not, we can still offer additional
suggestions.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[gllincoln]

Hi,

"Something" is corrupted, messed up in the database.

It happens from time to time, particularly if you have been in 'development'
mode, changing things, writing some code that crashed, etc.

First step is compact/repair.

If no joy, try copying each form to a new name using the database window,
see if that helps. When you copy a form that way, certain stuff may get
corrected.

If that doesn't solve the problem - create a new blank database and import
all of the objects into it.

No joy, another step you might consider trying would be to import the tables
and then the forms, one at a time, see if you can figure out which object is
'the one'.

If it still crashes the same way, it could be something wrong with Access
the program, instead of the database.
You might want to run the Office Repair - from Control Panel, add and remove
programs will bring up the installer.

Hope this helps...

Gordon