Jim Lawrence
accessd at shaw.ca
Mon Feb 25 20:03:48 CST 2013
Agreed Darryl. Have been using that method for going on 15 years and never had any issues. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Monday, February 25, 2013 2:55 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Bind Form to RecordSet True, But what I used to do when using SQL server for similar things is to download the SP data into a form and allow the user to edit the unbound record and then use an update query to write it back into the SQL BE database when they were ready. The main trick is to ensure you pull down all of the supporting data for the form as well (say to create valid combo box choices for that selection et al). It was very fast and worked well. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, 26 February 2013 9:47 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Bind Form to RecordSet As I pointed out on the SQL Server list, a SP returns a snapshot, not a persistent recordset, so you can pull the SP data with a pass-through query and can "bind" the data by setting a form's recordsource to the query - but it is RO, no create/edit/delete possible. -- Stuart On 25 Feb 2013 at 10:16, Jim Lawrence wrote: > Hi Arthur: > > I have had no experience using SPs with MySQL as it is a fairly resent > addition to the product (5 years?). > > Stuart seems to be able to do it with no problem though. ;-) > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur > Fuller > Sent: Monday, February 25, 2013 9:33 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Bind Form to RecordSet > > I figured that out, Charlotte. Now I'm on to new problems. I want to > execute a stored procedure in a MySQL database and assign the result > set to the RecordSet of a form. Any suggestions how to do that? > > A. > > > On Mon, Feb 25, 2013 at 12:23 PM, Charlotte Foust > <charlotte.foust at gmail.com > > wrote: > > > The RecordSource property takes a string. When you bind a form to a > > recordsource name, you get a DAO connection. The Recordset > > Property, as opposed to the Recordset Object, is for ADO binding. > > > > Charlotte > > > > On Sun, Feb 24, 2013 at 1:51 PM, William Benson (VBACreations.Com) < > > vbacreations at gmail.com> wrote: > > > > > What the ...??? > > > > > > Maybe I am coming in too late on this thread to understand the > > > import of this statement, which all are apparently taking as fact > > > so I guess I may > > as > > > well take it as fact too ... but ... I *never* would have thought > > > that access forms could be bound only to adodb recordsets as > > > opposed to DAO recordsets. I mean after all, ADO came along later > > > in the Access > > lifecycle > > > than DAO, correct? And weren't forms always able to be bound to > > recordsets? > > > > > > I feel totally lost in this. > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com [mailto: > > > accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov > > > Shamil > > > Sent: Sunday, February 24, 2013 2:08 PM > > > To: Access Developers discussion and problem solving > > > Subject: Re: [AccessD] Bind Form to RecordSet > > > > > > Hi Arthur -- > > > > > > Access forms can be bound to ADODB recordsets only. > > > > > > -- Shamil > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > -- > Arthur > Cell: 647.710.1314 > > Prediction is difficult, especially of the future. > -- Niels Bohr > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com