inpossible to link data control with ACCESS 2000 database

[Stefan29]

Hi, me again,

I want to link Visual Basic Version 5 with a access 2000 database but a error message appears "Does not recognize filename.mdb database". With an excel-database it works fine. I have seen the same question at the forum for Visual Basic Version 6. The solution there was to download the service pack 4 Visual studio 6. I have tried to install the service pack 3 of visual studio 97 (that is also applicable for Visual Basic V5) but it isn't resolved. Is there a possibility to link a data control in Visual Basic Version 5 with an Access 2000-database?

Thank you for your help!

 

[Foada]

I am guessing you are connecting to the db using DAO?? If you are Access 2000 needs DAO ver 3.6 which you can also download from Microsoft. If you choose to battle wits with the witless be prepared to lose.

 

[flysti]

Ok I just encountered this problem as well.

Apparently Visual Basic is not compatible with Access 2000, it will only recognise Access 97.

What you have to do is open your Access 2000 database and convert it back to 97.

To do this open Access 2000
click on Tools ---> Database Utilities ----> convert databse

then select Access 97 and create a new DB file.

THen load up VB and link the created file as your database and thats it!

 

[CCLINT]

>Apparently Visual Basic is not compatible with Access 2000, it will only recognise Access 97.

Not true. There were just certain "Bugs" in the data control, or, in the case with a connection object, the wrong JET provider version was used.

You need to have the updated data control from SP3 (or was it SP4?) and change the connection property to read "ACCESS 2000"

You also need to use the OLEDB Data control, instead of the standard Data control, if you are using ADO and not DAO.
You can add this under PROJECT|COMPONENTS.

[/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!}