Report based on recordset

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?
 
D

Duane Hookom

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.
 
N

Newbie

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
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to automate update on weekly reports spreadsheet 0
Creating a Chart on form from selected data in query. 0
Link a text box based on drop down box with four options MS Word 365 0
Automation of scanned file storage based on content 0
Can I save a sql statement generated by a search form? 1

Top