Jim Lawrence
jlawrenc1 at shaw.ca
Mon Feb 25 12:04:01 CST 2013
Hi Arthur: I have posted this link a number of times and even though it is not specifically and only about your requirement, it does give you a sample of the methods to be able to use ADO to pull data from tables, from any BE and how to then transfer that data to your DAO tables. http://www.databaseadvisors.com/newsletters/newsletter112003/0311UnboundRepo rts.asp This code sample comes from the late 90s and it still works perfectly. If you need details just ask. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Sunday, February 24, 2013 2:46 PM To: Access Developers discussion and problem solving Cc: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] [AccessD] Bind Form to RecordSet I'm having another problem, too. I should mention that the BE for this app is a MySQL database. The Access app is hooked to it with ODBC. Everything works as it did when talking to an Access BE. One large impediment: Access can see the tables just fine, but seems unaware of the existence of Views and Stored Procedures in the BE. (Or at least, they're not visible, and setting the form's recordsource to a View that I know is there and know it works, because I can see it in Navicat, just not in Access.) Does anyone know how I can set the RecordSource to a View instead of a Table? Is there some special way to refer to it? dbname.viewName didn't work. Followup question: How to set the RecordSource to the result set returned by a Stored Procedure? I've done this in an ADP before, but that demands a MS SQL BE. I'm going to double-post to the SQL list, because this part of the discussion might belong there. TIA, Arthur On Sun, Feb 24, 2013 at 4:58 PM, Susan Harkins <ssharkins at gmail.com> wrote: > Quack! :) > Susan H. > > Ah, Susan! My lovely little duck! I didn't even look up the link you >> provided. I knew at once that you were right. A quick edit and presto. >> >> Thanks! >> >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadviso rs.com/mailman/listinfo/accessd> > Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> > -- Arthur Cell: 647.710.1314 Prediction is difficult, especially of the future. -- Niels Bohr _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com