A SQL Server and Access Question

How do you execute a SQL Server stored procedure or query from an Access mdb?
Thanks.
VBA
http://sqlservercode.blogspot.com/
"John Lane" wrote:

> How do you execute a SQL Server stored procedure or query from an Access mdb?
> Thanks.
|||By executing a pass-through query if the results are intended to be
read-only, or querying a linked table if you need the results to be
updateable. You can use DAO via VBA for this, or simply set a form or
report to the pass-through query. If you have follow-up questions,
post on microsoft.public.access.odbcclientserver -- that's where the
Access experts hang out, and you'll likely get a wider range of
responses than posting here.
--Mary
On Thu, 13 Oct 2005 13:45:08 -0700, SQL
<SQL@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>VBA
>http://sqlservercode.blogspot.com/
>"John Lane" wrote: