Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Visual Basic Applictions Project Corrupt

I'm converting access97 dbs to Access2000 and I get the message "The visual Basic for Applications Project in the Data Base is corrupt"  and the conversion shuts down.

What do I do to correct this problem?

Thanks

Elton
0
katzwhite
Asked:
katzwhite
1 Solution
 
LambertHeenanCommented:
you could try decompiling the A97 database before doing the converison to A2K.

Back it up first and then run this command...

[Path To MS Access97]\MsAccess.exe /decompile "Your Database.mdb"

Then attempt to convert it to Access 2000
0
 
Mach1proCommented:
Try opening the Access97 project in Access 97.  Run the database repair utililty, then open up a code module and Compile and save All.  Run a compact of the database and then try converting it again if you successfully went through the last 3 steps with no errors.
0
 
katzwhiteAuthor Commented:
Found some ophaned code on the first compile, then compacted and tried to convert, said couldn't convert some forms, couldn't find anything wrong with the forms, so tried the compile all option again, and then the convert, still problems with form conversion, tried third time and it converted.

Don't know what was different, but it worked so thanks for the help.

Best

Elton
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now