I'm using MS Access 2003.
I have a custom function that opens a recordset using a temporary pass-thru QueryDef object. Here's the guts of my code:
Public Function OpenRecordsetPassThru(ByVal pstrSQL As String, Optional ByVal pstrDatabase As String = "ORACLE", ...) As Recordset
On Error...