Report based on recordset

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi
I am using Access XP and SQL Server 2000

I have an mdb and I am trying not to have any linked tables.

Is it possible to base a report on a recordset?

If yes, how?
 
Reports don't have a recordset like forms. You could create a sql string as
the record source. The sql can pull directly from a table in a remote mdb
without linking the table.
 
Thanks

how will this work with ADO at the moment the recordset is created using a
command.execute statement

I am linking into SQL Server

Al
 
The method that I suggested has nothing to do with ADO or recordsets and I
don't believe it would work with SQL Server. You can link to the SQL tables
and set them to hidden.
 
Back
Top