Stuart McLachlan
stuart at lexacorp.com.pg
Sun Feb 24 19:19:22 CST 2013
I've also just createa a simple stored procedure in phpMyAdmin - (select * from mytable) and accessed it with a pass-through query. Both the view and query are visible/selectable/usable in a Form's "Record Source" dropdown list. (This is all in Access 2010) -- Stuart On 25 Feb 2013 at 10:57, Stuart McLachlan wrote: > 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 > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >