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

Senin, 25 April 2016

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

Duane,

That was easy. Thanks.

Now, the decision of which record sources to create as SP in SQL, and which as PT queries in Access. That's more of a business/personnel question than a technical one. I'm not the SQL dba. Either way, I can write most of the SQL code.

Another question is what to do if I need to update underlying data? I assume that would go something like:

Create unbound text/combo fields on top of the bound fields. When clicking into the bound field, unhide and move focus to the unbound field.
Write SQL, and VBA to execute the SQL to update the underlying table(s).
Refresh the form

Adam

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

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: runuphillracing@yahoo.com

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)