Report based on ADO recordset

  • Thread starter Thread starter Al Newbie
  • Start date Start date
A

Al Newbie

Access 2003

I have a report that at the moment has all the data from a recordset
inserted into a table and then uses the table as its recordsource (the
recordset is coming from SQL)

Is it possible to base the report directly on the recordset?

If yes how

Thanks
 
Al:

You can use the recordset as the record source for a report in an Access
project (.adp) but not in a JET database (.mdb). The following link gives
more information on how to do this for an Access project.

http://support.microsoft.com/default.aspx?scid=kb;en-us;301987

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Access 2003

I have a report that at the moment has all the data from a recordset
inserted into a table and then uses the table as its recordsource (the
recordset is coming from SQL)

Is it possible to base the report directly on the recordset?

If yes how

Thanks
 
Back
Top