VBA is corrupt in 2000

[edowling]

I have a database that I built in Access 97. I recently took it home to work on some VBA coding over the weekend and tried to open it in Access 2000 (which is what my home computer has). When I tried to open the database, I got an error saying that my "Visual Basic For Applications is corrupt" and the database wouldn't open. I tried creating a new database and importing all the queries, tables, forms, etc. The queries and forms and macros imported fine but the forms did not. I got the same error and couldn't open them. The really odd thing is that even a simple form that I did not create (it came off a CD in the Access 97 Developer's handbook) wouldn't open. So it's not necessarity my VBA.

Has anyone seen this before? Is this an Access 97 - 2000 issue?

Is there any way to open this database in 2000?

I opened the database on my work computer this morning and it works fine!

Thanks for the help,

Lis

 

[tlbroadbent]

Have you tried to create a new form and add code to it at home in Access 2000? Or have you created a module? That would determine if it was in fact a problem with the database or VBA in Access 2000. You may need to reinstall Access 2000. Terry

http://members.home.net/tlbroadbent/index.htm

 

[edowling]

No, I haven't tried creating a new form. The code is liked directly to the form, it's not stored in a module. So, I can just copy the code and paste it behind the new form and try to run it.

I'll try that tonight.

Thank I'll try reinstalling Access 2000.

Thanks,

Lis

 

[TheInsider]

Open the code window and choose Debug/Compile and Save All Modules. Check your References to ensure that nothing is missing. Rob Marriott
rob@career-connections.net

 

[Rhonin]

I recently ran into this and posted a help!!!

What I ran into was when I tried to import just a MODULE from 97 to 2K 2K would scan my entire app and would hang up giving me a vague reference to a form or report. Then it would give me a VBA corrupt message.

What I had to do was edit the froms/reports and repair or remove the dead links. The it would convert and/or import the information I requested.

As I have installed the ACC Dev 97 handbook, and the handbook contains reference code to other 97 sample databases, 2K will not properly run or convert it. It seems to be unable to follow the links/references in a 97 db unless ALL of the 97 bd's are loaded.

Hope this helps. I have used this for several LARGE apps in Access97 that I converted to 2K