Visual C++ Runtime Error

[Guest]

I have a simple Access Project application -- only one form with a VBA module
associated. Whenever I try to edit this module, even add a single space or
type a single letter, I get a Visual C++ Runtime Library error message that
says:

"Runtime Error!
Program: C:\ProgramFiles\MicrosoftOffice\Office11\MSACCESS.EXE
This application has requested the Runtime to terminate it in an unusual
way. Please contact the application's support team for more information."

The code itself is trivial. I only have a simple Case Select block of about
12 lines. I can edit this file with no problem on other machines, but Access
instantly closes whenever I try to touch this module. I have reinstalled
Office 2003, but it didn't help. Before I take the nuclear option and
reinstall Windows XP I would like to explore any and all alternatives. (I
don't even have Visual C++ installed but I do have Visual Web Developer
Express 2005.)

Please help!

 

[Guest]

You may have a corrupt mdb.
First, try copying the form's module to a text file (NotePad or WordPad will
do).
Go into the Form's properties and set Has Module to no.
Save and close the form.
Close the database.
Decompile the database. From the Windows menu, Start, Run, then put in the
path and name of the database with the decompile switch (example):
msaccess /decompile "E:\dev ciscms\devciscms.mdb"

Open the database.
Open the form in design view.
Change the Has module back to yes.
Open the forms module and paste the code back into place.
Compile the code.
Compact and repair the datbase.
Hope for the best.

I know that you are getting a different error message, but you might visit
this site to see if there is anything relevant:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

 

[Guest]

Thank you for the helpful response. Hoping for the best (and all of the
preceding steps) didn't help, but the more drastic approach suggested in your
link (i.e., start with a brand new .adp file, import all the forms w/o
modules, and then paste back the modules as text) seems to be working for now.

This is the third time this has happened in the space of a couple of months
(both .mdb and .adp files are affected), and the supposedly corrupted files
can be edited just fine on other machines. Any guesses about what I can do,
short of wiping the hard disk and starting over, to keep this from happening
in the future? I'm fully up to date on Office updates, and I've already
tried reinstalling Office11 to no effect.

You may have a corrupt mdb.
First, try copying the form's module to a text file (NotePad or WordPad will
do).
Go into the Form's properties and set Has Module to no.
Save and close the form.
Close the database.
Decompile the database. From the Windows menu, Start, Run, then put in the
path and name of the database with the decompile switch (example):
msaccess /decompile "E:\dev ciscms\devciscms.mdb"

Open the database.
Open the form in design view.
Change the Has module back to yes.
Open the forms module and paste the code back into place.
Compile the code.
Compact and repair the datbase.
Hope for the best.

I know that you are getting a different error message, but you might visit
this site to see if there is anything relevant:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

I have a simple Access Project application -- only one form with a VBA module
associated. Whenever I try to edit this module, even add a single space or
type a single letter, I get a Visual C++ Runtime Library error message that
says:

"Runtime Error!
Program: C:\ProgramFiles\MicrosoftOffice\Office11\MSACCESS.EXE
This application has requested the Runtime to terminate it in an unusual
way. Please contact the application's support team for more information."

The code itself is trivial. I only have a simple Case Select block of about
12 lines. I can edit this file with no problem on other machines, but Access
instantly closes whenever I try to touch this module. I have reinstalled
Office 2003, but it didn't help. Before I take the nuclear option and
reinstall Windows XP I would like to explore any and all alternatives. (I
don't even have Visual C++ installed but I do have Visual Web Developer
Express 2005.)

Please help!

 

[Guest]

Sorry, you are over my head now. As a last resort, I would reinstall
Windows, and office, and if it happens again do the unthinkable - contact
MicroSoft.

Thank you for the helpful response. Hoping for the best (and all of the
preceding steps) didn't help, but the more drastic approach suggested in your
link (i.e., start with a brand new .adp file, import all the forms w/o
modules, and then paste back the modules as text) seems to be working for now.

This is the third time this has happened in the space of a couple of months
(both .mdb and .adp files are affected), and the supposedly corrupted files
can be edited just fine on other machines. Any guesses about what I can do,
short of wiping the hard disk and starting over, to keep this from happening
in the future? I'm fully up to date on Office updates, and I've already
tried reinstalling Office11 to no effect.

You may have a corrupt mdb.
First, try copying the form's module to a text file (NotePad or WordPad will
do).
Go into the Form's properties and set Has Module to no.
Save and close the form.
Close the database.
Decompile the database. From the Windows menu, Start, Run, then put in the
path and name of the database with the decompile switch (example):
msaccess /decompile "E:\dev ciscms\devciscms.mdb"

Open the database.
Open the form in design view.
Change the Has module back to yes.
Open the forms module and paste the code back into place.
Compile the code.
Compact and repair the datbase.
Hope for the best.

I know that you are getting a different error message, but you might visit
this site to see if there is anything relevant:

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

I have a simple Access Project application -- only one form with a VBA module
associated. Whenever I try to edit this module, even add a single space or
type a single letter, I get a Visual C++ Runtime Library error message that
says:

"Runtime Error!
Program: C:\ProgramFiles\MicrosoftOffice\Office11\MSACCESS.EXE
This application has requested the Runtime to terminate it in an unusual
way. Please contact the application's support team for more information."

The code itself is trivial. I only have a simple Case Select block of about
12 lines. I can edit this file with no problem on other machines, but Access
instantly closes whenever I try to touch this module. I have reinstalled
Office 2003, but it didn't help. Before I take the nuclear option and
reinstall Windows XP I would like to explore any and all alternatives. (I
don't even have Visual C++ installed but I do have Visual Web Developer
Express 2005.)

Please help!