Building a DAO recordset in memory

[Glasgow]

I do not know how to build a recordset in memory (with no underlying database) under DAO. Under ADO I can do the following:

Dim rsTemp As New ADODB.Recordset
With rsTemp
.Fields.Append "SchMnemonic", adVarChar, 40, adFldUpdatable
.Fields.Append "SchStartDate", adDate, , adFldUpdatable
.Fields.Append "SchEndDate", adDate, , adFldUpdatable
.Fields.Append "SchLevels", adInteger, , adFldUpdatable
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
End With

Can I do something similar under DAO? If so, an example would be appreciated. Thank you.

 

[MichaelRed]

I don't thik so. DAO is nore-or-less file orientated as in Disc based file. You can achieve some of the functionality with UDTs or other array based concepts, or you can create and ACTUAL recordsets in ACTUAL db's and distroy them at the conclusion of your exercise - BUT I do not think you can create virtual DAO recorsets.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[Glasgow]

Thanks for making the effort to reply to my query, Michael. It has not come as a big surprise that this may not be possible - I certainly couldn't find anything in the documentation.