Conversion Problem 97 to 2000

[metlrg]

I have an Access program that I wrote 10 years ago (using Access97, I
believe. It might have even been Access 2.0). It is still being used and
runs pretty much as designed. Anyway, I got to the 'backside' of the program
and it does not show any of the objects (tables, queries, reports or macros).
It even gives an error as I try to go from screen to screen.

To work on the program, I copied the program onto another drive. When I
tried running the copy of the program, my Access 2000 program asked if I
wanted to convert the file. It then determined that the 'Visual Basic for
Applications project in the database is corrupt'. It wouldn't convert or
even open the program.

Side issue(?): There was an old copy of the database in the same directory
that appears to still have all the objects (tables, queries, etc.). The
problem with that program is that it doesn't have any data since about 1999.
The last modification date recorded is in 2004.

Questions:
1) Is there any way to get to the objects within the main database?
2) If the objects aren't there, how is the program continuing to run?
3) Why is the program running on one computer, but the copy on another drive
seems to be too corrupt to run?

Thanks for any help.

 

[Jerry Whittle]

I don't believe that you can convert from A2 to A2K in one step. That might
be the problem right there if you don't remember the version of the database.

You could try creating a new database file and importing the objects from
the old file into the new one. If you can just get out the tables, then you
could import that data into the old copy that still seems to work.

Assuming that it is corrupt, Tony Toews has an excellent web page on
database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp