[AccessD] Harnessing SQL Server with runtime

No, I do not bind to a pass through except in the case of a combobox 
or report.  If you bind to a pass through, it is not editable.
So, I only bind to them to things that I would not be editing.

I use views for all my binding.  Having also been and am a SQL Server 
DBA, I do not allow direct access to the SQL tables.

At 07:04 AM 3/18/2011, you wrote:
>Date: Fri, 18 Mar 2011 08:04:03 -0400
>From: jwcolby <jwcolby at colbyconsulting.com>
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Harnessing SQL Server with runtime
>Message-ID: <4D834A33.1030607 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>Robert,
>
>Are you using bound forms?
>
>Does anyone know how to compare binding to pass through query as 
>opposed to binding to ADO recordset?
>
>It seems that binding to a pass-through would leave me in DAO which 
>my framework supports already.
>Binding to an ADO recordset leaves me in ADO.  It is totally unclear 
>to me what goes on in either
>case "behind the scenes" pulling records from SQL Server, updating 
>the records, updating back to SQL
>Server and so forth.  In a few months or so I will have a better 
>idea of what actually happens but
>it is tough to make design decisions without already knowing this stuff.