Report with ADODB.Recordset

[Guest]

How can I use a ADODB.Recordset as datasource of a report.
The data is in a SQL Server.
I have no problem connecting to the SQL Server and I can use the data in
Forms or in any SELECT, UPDATE, DELETE and INSERT SQL statements without any
problem.

Only with reports it doesn't work.

In the Report_Open event of the report I get a 2593 Runtime-error:
This function is not available in a MDB
at the commandline: Set Me.Recordset = MyRecordset

 

[Guest]

Also posted this in de 'dutch' NG -- replied there...

Remove the me. in front of the recordset

Maurice

 

[Guest]

Dear Maurice,

Thanks for your answer (both in the English as in the Dutch DG).
I did try to remove the Me. in the expression but the same error keeps
comming.

Set Recordset = MyRecordset

Run time-error 2593
This function is not available in a MDB

As I indicated I have no problem connecting to the SQL Server and I can use
the data in Forms or in any SQL statements in my code without any problem.