VB6 and Access 2002

[kennedymr2]

I have written a vb6 (sp6) program on my computer , which uses an access 2000 database
I am running code similiar as follows.

Set db1 = OpenDatabase("c:\Test.mdb")
Set rst1 = db1.OpenRecordset("NFiles", dbOpenTable)
Set rst2 = db1.OpenRecordset("RFiles", dbOpenTable)

ie. I am not using ado

=====================================
Most of the results i get are the same, but, when i use a "seek" in the vb6 program, it appears it is not working the same on the xp computer with access 2002 on it. ie , no errors but the $$$ results are different.

Is there an incompatibility problem with vb6 and access 2002??????

Have posted to this forum, as it seems more of a vb6 problem.

Appreciate any advice.

Regards Kennedymr2

 

[kennedymr2]

Note:

I have now persued this problem a little furthur, and have altered all the code from DAO to ADO, and i believe this has solved the problem.

The problem , i believe, was the seek command was not working properly using DAO.

Could it be that DAO is running out in vb6 and now Ado should be used.?????

Regards Kennedymr2

 

[ucsjimj]

I think MS 2000 changed the way records may be selected, it is really designed for ADO using the selection process with keyed data. I agree the DAO process is on it's way out.

 

[kennedymr2]

ucsjimj (Programmer)

Thanks for your comment.
Will stick to ADO from now on !!!!


Regards Kennedymr2