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.

Thanks

This link has a converter that may be of use to you.

http://www.mvps.org/access/modules/mdl0052.htm