[AccessD] Access 2K to SQL Server

CREATE PROCEDURE stpSomeNameHere (@AsOfDate AS DATETIME) AS
SELECT * FROM vwSomeView WHERE SomeDate >= @AsOfDate

Modify the querydef as needed for the input parameter in Access.



On Mon, Jan 24, 2011 at 12:50 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> One of my clients is mired in Access 2K.  He is linking to views in SQL
> Server but these are fixed views that at this point are pulling hundreds of
> thousands of records when he really only needs the last X days, or for Claim
> X etc.
>
> How can I create a view (or stored procedure) out in SQL Server that
> accepts a parameter such as a date or a claim ID and allow sql server to
> perfrom the filter and return a small result set.
>
> REMEMBER this is A2K.  It is my understanding that A2K does not allow some
> of the fancy stuff that later versions of Access allows - like binding a
> form to an ADO recordset and having it be R/W.
>
> Any help would be hugely appreciated.
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>