VBA Corrupt

[Hank]

Try to open Access file and received this error: the VB for
application project is corrupt.

I created a new db and imported the entire object except Tables from d
backup. The backup opens minus 2009-2011 records.

Try to import d tables from d main db and it shows same error.

What do I do to salvage my tables from d main database. Also to open
it in 2005, same error message.

 

[Access Developer]

I presume you already tried Compact and Repair Database?

Is your database split... users each have frontend with tables linked to
data in backend in a shared folder?

How recent is your last complete backup? (Or should I not ask? If none,
you may have to settle for "an object lesson in the importance of frequent
backups". Example, I maintain a membership database for a non-profit
organization and I make a backup copy of the tables and data each time
before I perform the monthly updates. If I had some significant updates
between the regular monthly updates, I'd back it up before doing those,
too.)

What do you mean by "Also to open it in 2005, same error message" ?

Did you try creating a new, empty database, linking the tables to the tables
in the one giving you problems, and trying to use a make-table Query to
create copies of the tables/data in the new database?

Larry Linson
Microsoft Office Access MVP

 

[David-W-Fenton]

m:

Try to open Access file and received this error: the VB for
application project is corrupt.

I created a new db and imported the entire object except Tables
from d backup. The backup opens minus 2009-2011 records.

These are two very different errors.

A corrupt VBA project does not have any effect whatsoever on the
data stored in your tables, so you've got two kinds of corruption
simultaneously.

You've also not split your database into front end
(forms/reports/etc.) and back end (tables only). Had you done so,
corruption in the one could not have a corrupting effect on the
other.

Because you've got so many things wrong and because you've been
doing things so completely wrong, I'm not optimistic that you'll be
able to recover your VBA project or your data, unless you have
proper backups.

 

[Michael J. Strickland]

If a form or report is corrupted, try this:

1. Import a report or form from another database that you know is good.
2. Run (double click on) the form or report.
3. Break into the running code (Hit Ctl-Brk).
4. Stop the running code (Click on Run-> Reset or click the Reset button).
5. Re-compile the code (Debug-> Compile [database name] ).
6. Click Debug-> Compile [database name].
7. Save the form or report (Click File->Save or hit the Save button).
8. Close the code window (X in upper right corner or code window).
9. Save database.
10. Close database.
11. Re-open database and see if it works.

If it works, you should probably Compact & Repair and then save database again.