Senin, 25 April 2016

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



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

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.




Posted by: Duane Hookom <>
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:

Posting Komentar