Arthur Fuller
fuller.artful at gmail.com
Sun Feb 24 16:45:41 CST 2013
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://databaseadvisors.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