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

Jim Lawrence jlawrenc1 at shaw.ca
Mon Feb 25 12:04:01 CST 2013


Hi Arthur:

I have posted this link a number of times and even though it is not
specifically and only about your requirement, it does give you a sample of
the methods to be able to use ADO to pull data from tables, from any BE and
how to then transfer that data to your DAO tables. 

http://www.databaseadvisors.com/newsletters/newsletter112003/0311UnboundRepo
rts.asp

This code sample comes from the late 90s and it still works perfectly. If
you need details just ask.

Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Sunday, February 24, 2013 2:46 PM
To: Access Developers discussion and problem solving
Cc: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] [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://databaseadviso
rs.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
_______________________________________________
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