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

Arthur Fuller fuller.artful at gmail.com
Sun Feb 24 16:45:41 CST 2013


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


More information about the dba-SQLServer mailing list