The Visual Basic for Applications project in the database is corru

[sy]

I had problem opening up the vba coding after I add in all the changes I want
to add for the current database system. I need to add in a few more
functions, form, reports. No matter what is the sequence I add it in to the
database, I will faced the same problem. I do try do change the sequence to
add in the changes and compact after every steps. It looks find until I add
in everything changes to be done. I had try the solutions to export all the
objects in the database to a new empty database before I make any changes. I
then try to add in all the changes to be done and I'll not had the "The
Visual Basic for Applications project in the database is corrupt" problem
anymore but then I'll have another problem. This is caused by the coding
sytle used when the developer develop this project. He's using the syntax
me.button5 rather then forms!report!button5 he will use the same form to save
as another name. Therefore when I click on the button I will halt and I need
to change the "me." to "forms!report!". I therefore try to change in the vba
all the "me." to "forms!xxx!". After I change all the syntax, I will get the
message "The Visual Basic for Applications project in the database is
corrupt". After I get this message I can't either compact or repair the
database.

Is there any solutions to solve this problem?

 

[TomU]

I suggest trying to decompile your app:
Open a command line window and enter something like:
"C:\Program Files\Microsoft Office\office10\msaccess.exe" /decompile
"C:\MyPath\MyDatabase.mdb"
(You'll have to adjust this for your version of Access, its install
location, and the location of your application.)

Then compress and repair twice.

The source of your problem may be editing your VBA code while VBA is in a
break state because of an error. You should reset VBA out of this state
before changing code.

 

[sy]

I had try on the solutions you mentioned. I make sure the VBA is not in break
state before I edit anything. But still after I add in new process and
compile the vba code, I will get the message "The Visual Basic for
Applications project in the database is corrupted" when I try to compact the
database. Is there others solution can be doem to solved this problem?
Thank you.

=====
sy