Solved

Visual Basic Applictions Project Corrupt

Posted on 2002-04-02
3
224 Views
Last Modified: 2013-11-25
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
Comment
Question by:katzwhite
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 11

Expert Comment

by:LambertHeenan
ID: 6913549
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
 
LVL 6

Accepted Solution

by:
Mach1pro earned 100 total points
ID: 6913551
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
 

Author Comment

by:katzwhite
ID: 6913935
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question