Access 2.0 to Access 97

[Nikki]

I have a vb 3.0 application that accesses data in an
Access 2.0 database. If I convert this database to Access
97 it no longer works saying unrecognizable database
format. Is there some way I can access Access 97 databases
from vb 3.0?

 

['69 Camaro]

Hi, Nikki.

Is there some way I can access Access 97 databases
from vb 3.0?

You'll probably need to upgrade your VB compiler as well. VB 3.0 creates
16-bit applications, whereas Access 97 is 32-bit, so if your VB application
is accessing database application objects in addition to accessing data,
then you'll likely run into problems. The "Unrecognizable database format"
error is due to incompatible database architectures. Access 2.0 uses Jet
2.x and Access 97 uses Jet 3.x for the database architecture.

If you have access to the VB project's source code, look to see whether the
data access provider is set up to use the Jet 2.x provider, so that you can
try changing it to Jet 3.x before recompiling. If you don't have access to
the VB project's source code, then you're out of luck.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Douglas J. Steele]

Hi, Nikki.


You'll probably need to upgrade your VB compiler as well. VB 3.0 creates
16-bit applications, whereas Access 97 is 32-bit, so if your VB application
is accessing database application objects in addition to accessing data,
then you'll likely run into problems. The "Unrecognizable database format"
error is due to incompatible database architectures. Access 2.0 uses Jet
2.x and Access 97 uses Jet 3.x for the database architecture.

If you have access to the VB project's source code, look to see whether the
data access provider is set up to use the Jet 2.x provider, so that you can
try changing it to Jet 3.x before recompiling. If you don't have access to
the VB project's source code, then you're out of luck.

As you said, Gunny, Jet 3.x is 32 bit, and VB3 was only 16 bit, so it's
doubtful that you'd be able to change the reference.