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

jwcolby jwcolby at colbyconsulting.com
Tue Mar 23 11:59:00 CDT 2010


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.
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, March 23, 2010 10:11 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] SPAM-LOW: Re: Binding forms and controls directly
> to SQL Server
> 
> OK, I can do that.  To make a query a pass through query I set a
> property of the query?
> 
> John W. Colby
> www.ColbyConsulting.com




More information about the AccessD mailing list