Cannot access Access 2000 db with VB5 using DAO 6.0.

[wcamp02]

I am attempting to use Visual Basic 5 (Sp3) to manipulate an Access 2000 db. I have read other posts on this topic which said to use Sp3 and check DAO6.0. I have done this.
I also downloaded Sp4 for Visual Studio 6. I will not install because I am using VB5.

Is there anyone who is actually reading Access 2000 files with VB 5?

Thank you.

 

[vbkris]

i have never worked with VB5, do u have an ADODB component?

 

[CCLINT]

You need to do it like this:

1. Create a recordset object variable with DAO 3.6 or ADO 2.5.

2. Open the recordset off of the table in question.

3. If you are using a DataControl(Data1) then set it's recordset to your newly created recordset variable:

Set Data1.Recordset = MyRs

 

[CCLINT]

> or ADO 2.5.

Sorry, just caught it rigth when submitting the post. I should have mentioned that you will not be able to use ADO with bound controls or the Data Control.
If you use these bound controls from VB5 you will need to use DAO 3.6 to set the recordset of the VB5 DataControl control.

 

[wcamp02]

Thank you. That did it.