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