Re: Using ADO Recordset for Source of Access Report in .MDB file

What I have done that has worked well is to create a PassThru query in the
access database and programmaticly change its Sql to return results needed
from any of the Server objects (Views, Sproc's, raw SQL, etc). I guess you
could take this to the next step and ONLY use PassThru queries, but we have
always had linked tables to the Sql Database too.

Rdub
"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA9BD389-9BF3-4550-A370-F92566D30B00@xxxxxxxxxxxxxxxx
I have a SQL-Server 2K backend that I am trying to communicate with. My
predecessor used a .MDB file as the front-end. I am trying to avoid linked
tables and cut down on network traffic.

-- Tom


"Ron Weiner" wrote:

Heck, I didn't think it possible to use any kind of recordset (dao, ado,
rdo, or any other xxo) as the RecordSource for a Report. My
understanding
is a report's RecordSource property can only be a table, query, or SQL
statement.

What is it you want to do?

Rdub

"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:552D3FD4-41BC-4071-AF20-6E45F9672105@xxxxxxxxxxxxxxxx
I am new to ADO and am trying to use it as the source for my MS-Access
reports in an .MDB file. I am getting conflicting reports as to whether
or
not that it possible.

Can anyone point to an example of how to use ADO to source my report?

Thanks,


-- Tom





.

Relevant Pages

  • Access Query - Between Operator showing additional data
    ... In one report i am using between operator in SQL to fetch data from access database. ...
    (microsoft.public.access.queries)
  • Re: A question on SQL
    ... Say I have an Access database containing a table with the following fields ... What is the SQL statement to generate the following result: ... I would not *DO* this using a query; I'd do it using a Report. ... very nice subtotaling tools, optional display, etc. - you're talking about a ...
    (microsoft.public.access.queries)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: SCAN.EXE - McAfee AntiVirus Software
    ... > | of network computers and have only report summaries sent to be via ... > | Virus Scan Report File ... > | application RemoteProcessLaunch. ...
    (microsoft.public.security.virus)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)