[AccessD] Feeding parameters to SQL Server

JWColby jwcolby at colbyconsulting.com
Wed Feb 21 11:58:47 CST 2007


Is it possible to feed a parameter to a SQL Server view from Access?  I am
linking (ODBC) to a pair of tables in SQL Server.  The views return a set of
data which will only grow larger over time.  I would like to somehow tell
sql server where... and feed in the value - where checkdate >=X and <=Y for
example.  These views are then used in queries inside of Access, linked to
my tables and stuff.
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 



More information about the AccessD mailing list