[dba-SQLServer] [AccessD] Bind Form to RecordSet

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
> 
> 




More information about the dba-SQLServer mailing list