[dba-SQLServer] dba-SQLServer Digest, Vol 35, Issue 29

Robert L. Stewart rl_stewart at highstream.net
Mon Jan 30 14:25:43 CST 2006


John,

Now I see.  The trick is that you cannot bind the form to the 
SP.  You are going to have to do it as an unbound form.  Then use 
additional SPs to do the updates and deletes.

Robert

At 10:09 AM 1/28/2006, you wrote:
>Date: Sat, 28 Jan 2006 10:16:23 -0500
>From: "John Colby" <jwcolby at ColbyConsulting.com>
>Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <002601c6241d$cd9ce1a0$657aa8c0 at ColbyM6805>
>Content-Type: text/plain;       charset="us-ascii"
>
>Build a SP in 2005 (express for me).  It is read-only, regardless of whether
>I try and edit the data it inside of SMSE or in a pass-through out in
>Access.
>
>I am trying to bind a form to a SP recordset.
>
>
>John W. Colby





More information about the dba-SQLServer mailing list