Are DAO's DOA in Access 2000? 2

[harryrich]

I've been reimplementing some Access 97 programming to Access 2000, perhaps my first mistake.

I created a recordset:

Dim RateSet as Recordset
Set RateSet = CurrentDb.OpenRecordset ("RateSet",dbOpenDynaset)

I found the RateSet.FindFirst, .FindNext, and .FindLast methods were unavailable. I looked up the Recordset methods in the help, and find that a Recordset is no longer a DAO but an ADO. All I can use with and ADO is the .Find method which is restricted to a single comparison on a single column.

This is not progress in the right direction for me.

Have I overlooked an installation option, or an alternate method of opening an Access table as a DAO in a VBA module? Or am I going to be staying on Access 97 for a very long time to preserve my algorithms?

Thanks,

Harry

 

[ghubbell]

DAO is not dead! In the VB environment Tools-References and check off Microsoft DAO 3.6 Object Library and possibly Microsoft VB for applications Extensibility 5.3.
You may need to shift their priorities to compile but it will work! Your algorithims are saved!
Gord
ghubbell@total.net

 

[Telsa]

I also found it helps to set the type as dao.recordset when declaring variables.

 

[harryrich]

Thanks. The suggestions worked just fine and have saved me weeks of work.

The situation waa especially confusing since Currentdb.OpenRecordset was returning an object with typename "Recordset", but the object could not be assigned to a variable of type Recordset.

Best,

Harry