ADO recordset errors when trying to set to form recordset

ADO recordset errors when trying to set to form recordset

Post by ruby » Fri, 02 Jan 2004 04:12:46


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.

Thanks.
 
 
 

ADO recordset errors when trying to set to form recordset

Post by Michae » Sat, 10 Jan 2004 04:04:40

Have you discovered the answer to your question? I am
doing the same thing, just not as far along, and I have
issues with running queries off the linked tables. I am
looking for a way to speed up the processing by moving my
queries into Oracle but don't know the first thing about
Oracle. Any suggestions.

Michael

possible.
SQL
works
instance.