Senin, 25 April 2016

RE: [MS_AccessPros] Opening SQL stored procedure in datasheet view

 

Adam,

You can create a pass-through query with an SQL property of:

EXEC usp_Proc1

You will need to set up the ODBC connection string. The returned data will be read-only but can be used as a record source for a form or report.


Duane Hookom, MVP
MS Access


To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 25 Apr 2016 15:40:09 -0700
Subject: [MS_AccessPros] Opening SQL stored procedure in datasheet view



How do I open a SQL stored procedure (SP) - e.g., named "usp_Proc1" - in Access datasheet view? This seems like a basic question, but I haven't been able to find a simple answer on the internet. The SP is a SELECT query. If needed, assume I have a connection string stConn.


The follow up need is how then to use that (and other) SPs as the recordsource for forms and reports.


Thanks


Adam


__._,_.___

Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!


.

__,_._,___

Tidak ada komentar:

Poskan Komentar