John Colby
jwcolby at ColbyConsulting.com
Sat Jan 28 10:09:13 CST 2006
Ohhhh... Thanks for that. I'll try it and get back. The strange part is I would expect it to be R/W directly in SMSE. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Saturday, January 28, 2006 10:38 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio john pt will return ready only. try open ur sp and assigning it using command object. dont use set rst=cnmd.execute. use rst.open cnmd -----Original Message----- From: "dba-sqlserver-bounces at databaseadvisors.com" <dba-sqlserver-bounces at databaseadvisors.com> on behalf of "John Colby" <jwcolby at colbyconsulting.com> Sent: 28 January 2006 15:16 To: "dba-sqlserver at databaseadvisors.com" <dba-sqlserver at databaseadvisors.com> Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio 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 www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart Sent: Saturday, January 28, 2006 9:37 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio I am already going that way and have been for over a year. The problem is that I essentially have wasted the last year because the difference between VS 2003 and 2005 is so radical. Now I am relearning. John, What is the SPs read-only problem? Can you explain what you are trying to do again? Robert At 12:00 PM 1/27/2006, you wrote: >Date: Fri, 27 Jan 2006 12:19:34 -0500 >From: "Susan Harkins" <harkinsss at bellsouth.net> >Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio >To: <dba-sqlserver at databaseadvisors.com> >Message-ID: <002a01c62365$e41183e0$aeb3d6d1 at SUSANONE> >Content-Type: text/plain; charset="us-ascii" > > >To be honest, once I get over the learning curve I am leaning towards >abandoning the MDB as a BE. > >========John, if I stay in this market, I am seriously considering the >same thing. > >Susan H. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com