Access 97 and 2000 conflicts ....can't open my database [Archive]

sumedha

07-16-02, 16:51

Hi!

I have an application developed in VB6 accessing two access mdb files. I have developed the application in Windows 2000 environment with Access 2000 but my client has Access 97 installed and my application needs to access their database. I have done the setup using Wise Installer 4.0 and it works fine. But when I installed it on the clients (Win NT) machine it failed accessing my database (created in Access 2000) I tried to correct this by converting the Access file to a prior version file but this still does not work. I need help with this and quick pls. help!!
Bewildered developer
:confused:

horvata

01-20-03, 14:42

Hi,
My tip is that, issue is comming up from your application... It's use MDAC from Windows 2000. In this case you need to correct database connection in VB6 code. After compilation you can't change database versions. I am not sure which version or components of MSDA do you need but you can find more information about that on Microsoft sites.

Attila