VB and ACCESS 2000

[F.Mayis]

Hi,

I have some database in access 2000.
I'd like to work with these databases in VB.

But my version of VB support an ACCESS database version inferior or equal to ACCESS97.

Is there a patch or something else, to make VB work with ACCESS 2000?

Thanks a lot!

[Iouri]

What VB version do you have?
I think if your version supports A97, it will support A2000. The only thing you have to use diffrent provider.
Microsoft Jet 3.51 OLE DB Provider for A97
Microsoft Jet 4.0 OLE DB Provider for A2000


Iouri Boutchkine
iouri@hotsheet.com

[F.Mayis]

I use VB6.

If i use MJet4.0 it will work!
which references i must select in my project?

Thanks!

[Iouri]

Open a project.
From the Project menu, click References.
From the list, select Microsoft ActiveX Data Objects 2.5 Library(or whatever version you have 2.1... etc (latest is 2.6))

'only if you need it
From the list, select Microsoft ADO Ext. 2.1 for DDL and Security.
From the list, select Microsoft Jet and Replication Objects 2.1 Library.

Iouri Boutchkine
iouri@hotsheet.com

[F.Mayis]

Thanks a lot!