ADO, DAO problems in Access 2002

[jon_sg]

Each time I try to use the [formname].Recordsetclone object in an Access 2002 .mdb it always returns a DAO object. Anyone know how to get it to return an ADO object instead without converting the file to an Access project.

It isn't really a big problem it just bugs me that I have to use both DAO and ADO in the same file, it also complicates the code that I have to write

 

[Mile-O]

Try using an ADODB defined recordset then.

Dim rs As DODB.Recordset
Set rs = Me.RecordsetClone

 

[jon_sg]

Thanks

Thanks for the help folks, I always get a type mismatch when I try to use ADO recordsetclone and I thought I was doing something wrong.

I have a tendancy to get the ADO and DAO syntax mixed up and end up doing a lot of debugging if I try to mix them. I would just like to use ADO and have done with it. Lets hope MS get it together in later versions.

 

[Mile-O]

In fact, since I still use A97 I'm not 100% on later versions but I'm sure I've seen code like:

Recordset.Clone


Don't know though...