Monday, January 4, 2010

Access97 mdb in WinXP

Recently, I was asked to migrate an application from the WinNT4 world to the WinXP world. Here is some details of the application.

Old WorldNew World
OS of the PCWinNT4 WS SP6WinXP Pro SP3
The Application is written byDelphi 4N/A
Database ConnectivityODBCODBC
DatabaseAccess 97 mdb fileAccess 97 mdb file

My first question is : Do I need to install Access97 in WinXP ? This article [[ Microsoft Access in Wikipedia ]] says that Access97 is not supported by the WinXP OS. Also, there is significant transition was from the Access 97 to the Access 2000 format.

After searching the net, it seems that there are many problems when running Access97 in WinXP. For example, this article [[ Access 97 Install Difficulty on Windows XP - System.mdw ]] shows a life experience about the difficulties for installing Access97 in WinXP.

Is it possible to setup ODBC driver for the Access97 mdb file in WinXP ?. This post [[ Access97 ODBC ]] is doing this thing.

This article [[ Microsoft Jet Database Engine ]] in Wikipedia says that :
The Jet DLL determined what sort of database it was accessing, and how to perform what was requested of it. If the data source was an MDB file (a Microsoft Access format) then it would directly read and write the data to the file. If the data source was external, then it would call on the correct ODBC driver to perform its request.

No comments:

Duplicate Open Current Folder in a New Window

Sometimes after I opened a folder in Win7, I would like to duplicate open the same folder again in another explorer window. Then, I can ope...