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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Also, you gave me an idea. I could create Views for all backend tables and
saved PassThru queries for all of them. It would involve a lot of re-codeing,
but I could swap out the references to the linked tables and refer them to PT
queries that call the views. What do you think?

-- Tom


"Ron Weiner" wrote:

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

  • Re: Using ADO Recordset for Source of Access Report in .MDB file
    ... milliseconds for a form to be loaded. ... from any of the Server objects (Views, Sproc's, raw SQL, etc). ... could take this to the next step and ONLY use PassThru queries, ... or any other xxo) as the RecordSource for a Report. ...
    (microsoft.public.access.reports)
  • Dynamically changing a reports recordsource property
    ... I have a report set up in Access 2003. ... the reports recordsource property during runtime. ... its' recordsource property and I need to change one condition in the sql ...
    (microsoft.public.access.modulesdaovba)
  • Re: Triplicate
    ... This would suggest that the Report is based on a Query which is ... find its Recordsource property, the first property on the Data ... SQL; and post the SQL text here. ...
    (microsoft.public.access.gettingstarted)
  • 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)