VB5 and Access database formats.

[Kraeg]

Can VB5 only access databases in Access 97 format?

I have created a VB5 application that accesses an mdb file to retrieve records; it will only access an mdb in Access 97 format.
I changed a reference to MS DAO 3.5 to MS DAO 3.6 in the application, but it still won't access an Access 2000 mdb (in the 2000 mdb there's a reference to MS DAO 3.6).

I guess I need to learn more about references, etc. (I've just been fudging it).

 

[Guest_imported]

I have had the same Problems.
What I have done is that I have installed Office 97 Pro. and made the Access File new. Pleac note that you shoud not copy the Data, you will have to writew it new.

But a differnt Problem i have is that the Program that I have made dose not work under Win2k. Dose anybody know why and what I can do ?

-=WIZARD MERLIN=-

 

[CCLINT]

To start, make sure you have the most recent version of Jet 4.0 (

http://www.microsoft.com/data/download).

You should be able to create a recordset object with DAO 3.6, connecting to an ACCESS 2000 db.

But, via the DataControl, you will not be able to.
However, there is a way to work around this.
Create a recordset object and connect it to the Db.
Then, Set the Data1.Recordset to the recordset object that was just created.

It this doesn't help, then you need to post more information and also the error messages you are receiving as well as how you are trying to access the database.

[/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}