Jim Lawrence
accessd at shaw.ca
Wed Jan 25 00:41:28 CST 2006
Hi John: 1. Set the ADO objects 2. Create an ADO connection. 3. Create a SP on the SQL that will accept parameters. 4. Set up a recordset to received data from the SP. 5. When the recordset is populated use its data to fill the combo/list box (use the old combo box object if you do not have it I will send you a working copy but I think you do.) Every time a change is made in the request (filter) processes from 1 to 5 are invoked. If you need code samples I will be glad to send then to you. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: January 24, 2006 9:10 PM To: 'Access Developers discussion and problem solving'; dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Moving some object's recordsource to SQL Server I need a "step by step" if you will of moving some object to SQL Server - combo or form - where the Access query was filtered and the filter won't work in SQL Server. For example a reference to a control on a form. I know that I have to create a SP in SQL Server that accepts a parameter. How do I "connect" to that query from Access? Is it a n ODBC (or other?) link, just like a table? Then how do I feed the parameters to the SP out in SQL server. I am getting ready to do this and am way under prepared for this. Environment: SQL Server Express 2005 Access (Office) XP or 2003 Fes now talking to the SQL Server BE using the standard (ODBC I think) "links" that the upsize wizard created when it moved the tables. The FE seems to work as it did before except slower. Now if I can start replacing the slow "Access Queries over ODBC" with "SQL Server SPs with passed params????" I might be able to see what this is capable of. I just haven't a clue how to move to that "SP with Params". John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com