[AccessD] Feeding parameters to SQL Server

Jim Lawrence accessd at shaw.ca
Wed Feb 21 14:07:08 CST 2007


Hi John:

There is a DBA related article on subject
(http://www.databaseadvisors.com/newsletters/newsletter112003/0311UnboundRep
orts.asp ... don't get scared off by the name.) which will give a sample FE
and BE DB on the design. 

ODBC works great for Updates and Deletes but when it comes to Selects that
is where everything grinds to a halt.  

The small attached code app was part of a much larger application that could
be accessed from anywhere in country, given the proper credentials and an
appropriate MS Access FE. It shows the method of attachment (an MS Access or
MS SQL BE work equally as well or any DB for that matter.), data management
and parameter passing.

If you need more specifics contact me offline.

Jim   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Wednesday, February 21, 2007 9:59 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Feeding parameters to SQL Server

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
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list