Jim Lawrence
accessd at shaw.ca
Mon Jan 30 15:07:51 CST 2006
I concur. There is third-party software that can emulate a bound connection, at a cost of course and then there is always a .Net solution. Jim PS I have been discussing this point for almost 10 years, Bound versus Unbound and that you just can not get here from there. The old ways die hard. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: January 30, 2006 12:26 PM To: dba-sqlserver at databaseadvisors.com Cc: jwcolby at ColbyConsulting.com Subject: Re: [dba-SQLServer] dba-SQLServer Digest, Vol 35, Issue 29 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com