SQL Server Performance

[ADO/SQL Server] How launch Access Reports?

Discussion in 'General DBA Questions' started by yoyocestmoi, Nov 13, 2003.

  1. yoyocestmoi New Member

    Hi,

    I'm converting my Access mdb application (Access Database) to SQL Server, that is an Access mdb file as frontend, and SQL Server as backend!

    To access SQLServer data, I'm using the ADO technology.

    I'd like to know what is the best way to launch and Access report using SQL Server tables (including temporary tables created with the ADO Connection)

    Thank you,

    Lionel M.
  2. satya Moderator

  3. yoyocestmoi New Member

    Hi,

    The link you gave me (thanks for it) is just about Access Reports.

    My concern is the launch of Access report based on SQL Server data.

    I know that I could use linked tables or Pass Thru queries, but as I'm using ADO Connections for all other things (for examples, for all my Access forms that are using SQL Server data), i'd like to use ADO for my reports as well, especially because these reports need to use Temp Tables created by my ADO Connection...

Share This Page