SQL view

[Mark]

I need a little help. I’m trying to use a view in an Access mdb as a record
source for a report. Normally, the views name could be the record source. But
since I have to define an ADO record set manually, I’m at a loss as to how I
get the view accepted by the report. Any help is greatly appreciated.
Access 2002
SQL Server Ver 8
Mark

 

[Albert D. Kallal]

Just create a linked table to the view on sql server....and then you can use
that just like any other linked table or query for the soruce of hte
repprot...

You should not need to use an ado recordset here at all. In fact you don't
even need to write any code here.

Simply create the view on the sql server side.

Then in ms-access simply go fle->get external data->link tables

Then simply choose in "files of type" ODBC Databases ()

When you go to link this table...you will see the view in the list of tables
and thus just choose the view you created on the sql side...