[AccessD] Bind Form to RecordSet

Rusty Hammond rusty.hammond at cpiqpc.com
Sun Feb 24 17:03:36 CST 2013


Arthur,

Are you linking to tables in MySQL?  If it works like MS SQL, you can
link to a view just like linking to a table.  As for stored procedures,
a common method is to call the stored procedure using a pass-thru query.

HTH,

Rusty
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Sunday, February 24, 2013 4:46 PM
To: Access Developers discussion and problem solving
Cc: Discussion concerning MS SQL Server
Subject: Re: [AccessD] Bind Form to RecordSet

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://database
> advisors.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
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************



More information about the AccessD mailing list