Solved

Visual Basic Applictions Project Corrupt

Posted on 2002-04-02
3
207 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
3 Comments
 
LVL 11

Expert Comment

by:LambertHeenan
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now