Visual Basic Error but I Don't Use Visual Basic

[Guest]

Hello,
Every time I try to do a compact/repair on my database, I get the the
following error message:
The Visual Basic for Applications project in the database is corrupt.

I am also not able to make changes to the forms or tables. I keep getting
that message and I have to do a ctrl+alt+del to get out of Access.

I have no idea what has this caused this. As far as I know, I don't use
Visual Basic.

Thank you in advance for any assistance you can provide!

 

[Guest]

Create a new MDB, and import all the objects from the old mdb to the new one,
and then try compact and repair

 

[John Vinson]

Hello,
Every time I try to do a compact/repair on my database, I get the the
following error message:
The Visual Basic for Applications project in the database is corrupt.

I am also not able to make changes to the forms or tables. I keep getting
that message and I have to do a ctrl+alt+del to get out of Access.

I have no idea what has this caused this. As far as I know, I don't use
Visual Basic.

Thank you in advance for any assistance you can provide!

If you've ever used the Form Wizard to (say) put a Find button or an
Open Form button on a form, *it* has written some VBA code for you.

I'm guessing you have (if you're lucky) just one form or report which
has become corrupted. Create a new, empty database, and import your
Tables and Queries. If it opens OK (it should but might not), start
importing Forms and Reports, one at a time; compact after each import.
If you get the error you now know which (or the first :-{( ) corrupt
object and can back up and repeat.


John W. Vinson[MVP]