Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Visual Basic Applictions Project Corrupt

Posted on 2002-04-02
3
Medium Priority
?
233 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
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 400 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

972 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