Access 97 to access 2002 database conversion

[ferrari1]

At work we are using access 97 for all of our records. We recently upgraded most of our computers to office xp. I have tried to convert the 97 database to 2002, but when doing so it give me errors. Such as the Doa of 97 is unrecognized. It shows code in Visual Basic, which I do not know, I only know c++ at the time. Is there anyway to get around this. I would think there has to be a way to just convert it straight over with out problems.

 

[FoxProProgrammer]

Unfortunately 100% of Access 97 code doesn't convert to Access 2000, although the changes might be minor. In instances where Access 2000 doesn't recognize DAO code, try explicitly specifying DAO as in the following examples:

Dim db As DAO.Database
Dim rs As DAO.Recordset

If you have specific questions about the code, you might find more help at the Access forums below.

forum705 you know C++, Visual Basic should be easy to learn. The only caviat is that VB for Access includes code that is specific to databases. Your main difficulty might be figuring out the database specific code. Best of luck with your conversion. If I can be of any help please feel free to send me an email and I'll try to give you a hand.





dz
dzaccess@yahoo.com

 

[FoxProProgrammer]

Part of my last post was cut off. Appartently you can only insert one hyperlink per post. The thread numbers are 700 (Access Tables and Relationships), 701 (Access Queries), and 181 (Access Other topics).

Best of luck. dz
dzaccess@yahoo.com