Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / February 2008

Tip: Looking for answers? Try searching our database.

Conversion Problem 97 to 2000

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
metlrg - 21 Feb 2008 19:17 GMT
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 - 22 Feb 2008 16:22 GMT
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
Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

>  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
[quoted text clipped - 20 lines]
>
> Thanks for any help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.