Convert ADO reocordset to DAO recordset use report
Hi, I'm new to access and need some help with a small glitch i've run into.
I'm using ADO to connect to a SQL 2000 server and run a stored procedure. Is there a way to convert the result set (ADO recordset) to DAO? Or for that matter: is it possible to set an Access report's recordsource to the ADO recordset itself?
Any suggestions would be greatly appreciated.