Stuart McLachlan
stuart at lexacorp.com.pg
Sun Feb 24 18:57:36 CST 2013
What version of mySQL and ODBC? I just created a view in a MySQL 5.5.20 and linked to it through MySQL OBDC n5.1 Driver with no problems. -- Stuart On 24 Feb 2013 at 17:45, Arthur Fuller wrote: > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >