Originally, the application was written with Access2000
front and back end. I'm moving the data to Oracle 9i and
recoding to use pass-through queries as much as possible.
I have converted most of the forms already, creating a SQL
string and using the .execute method to return the
recordset to display on the form:
Set rs = cnn.Execute(strSQL, adCmdText)
When I go to set the form recordset to this recordset:
Set Me.Recordset = rs
I get Error 2766: The object doesn't contain the
Automation object 'Recordset'.
I have used this same technique on many forms and it works
perfectly but this is a much more complex query and I'm
hoping someone knows what is causing this in this instance.