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

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
> 




More information about the dba-SQLServer mailing list