[AccessD] SPAM-LOW: Re: Binding forms and controls directly to SQL Server

Yes, I did.  In A2k and above that works.  ADO is the way to go on this, John.  You can call your stored procedure in code and pass it the parameters it need to return an ADO recordset.  My code library seems to have gone AWOL with my old machine, so I don't have the code at hand, but there are samples in my section of Roger's Access Library.  One of the sample, No Tables, does this kind of magic between two Access databases without table links.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, March 23, 2010 9:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SPAM-LOW: Re: Binding forms and controls directly to SQL Server

I seem to remember Charlotte saying that you could open an ADO RECORDSET and bind the form to that 
recordset to make the form read/write.

John W. Colby
www.ColbyConsulting.com


Rusty Hammond wrote:
>>From the SQL view of the query, go to the Query menu, SQL Specific,
> Pass-Through.  Then right click the title bar of the query and go to
> Properties.  Setup your ODBC Connect Str and you should be good to go.
> The SQL of the pass-through needs to be in T-SQL and not access sql.
> Pass-Through queries are read-only which is why I only use them for
> combo boxes or to call stored procedures.
> 
>