stored procedures in access - forum post summary

Using stored procedures in Access (From SQL Server)

Started 2 months, 3 weeks ago (2009-10-01 20:44:00) by jmprescott

I created a stored procedure in MS SQL Server 2005. Is it possible to execute that in Access? If so, how? I searched around a bit and couldn't find anything valuable. Thank you.

Source: Expert Communities - bytes

Forum: access

Thread: Show this thread (5 posts)

Size: 217 bytes
Related Threads: Same Site | All Sites
Customize:

re: Using stored procedures in Access (From SQL Server)

Started 2 months, 3 weeks ago (2009-10-02 15:10:00) by ADezii

Quote: Originally Posted by jmprescott Oh, that's great! Thanks a bunch. You are quite welcome. Here is a slightly different variation that will Execute a Stored Procedure in an External SQL Database utilizing the Return Value from the RecordsAffected Argument of the Execute Method. This approach does not pass a Parameter and makes use of Constants. ...

Source: Expert Communities - bytes

Forum: access

Thread: Show this thread (5 posts)

Size: 3,789 bytes
Related Threads: Same Site | All Sites
Customize:

stored procedures to access filestream data

Started 3 months ago (2009-09-23 15:35:00) by Franky

We would like to start using filestream in our webapplications. The NT-accounts we use to access the sql-data only have execute rights on stored procedures, no rights on the underlying tables. We would like to keep is this way. => Is this a problem when we start using filestream data. fe make a stored procedure in which the PathName() and GET_FILESTREAM_TRANSACTION_CONTEXT () is retrieved. I ...

Source: SQL Server Forum

Forum: Security

Thread: Show this thread (2 posts)

Size: 1,112 bytes
Related Threads: Same Site | All Sites
Customize:

RE: stored procedures to access filestream data

Started 3 months ago (2009-09-23 17:30:00) by Bob Beauchemin

Hi Franky, You'd need to begin the transaction in .NET code, then call the stored procedure, then use the streaming functions, then commit the transaction in .NET code when you are done. Cheers, Bob Beauchemin SQLskills > We would like to start using filestream in our webapplications. > The NT-accounts we use to access the sql-data only have execute rights on [quoted text clipped - 22 ...

Source: SQL Server Forum

Forum: Security

Thread: Show this thread (2 posts)

Size: 557 bytes
Related Threads: Same Site | All Sites
Customize:

stored procedures to access filestream data in microsoft.public.sqlserver.security

Started 3 months ago (2009-09-23 07:34:00) by Franky

Source: Discussions in microsoft.public.sqlserver.security

Forum: microsoft.public.sqlserver.security

Thread: Show this thread (2 posts)

Size: 1,614 bytes
Related Threads: Same Site | All Sites
Customize:

RE: stored procedures to access filestream data in microsoft.public.sqlserver.security

Started 3 months ago (2009-09-23 09:34:00) by Bob Beauchemin

Hi Franky, You'd need to begin the transaction in .NET code, then call the stored procedure, then use the streaming functions, then commit the transaction in ..NET code when you are done. Cheers, Bob Beauchemin SQLskills "Franky" wrote in message news:57F4348D-1BA6-4039-A675-C5CB00C93629@microsof t....

Source: Discussions in microsoft.public.sqlserver.security

Forum: microsoft.public.sqlserver.security

Thread: Show this thread (2 posts)

Size: 2,246 bytes
Related Threads: Same Site | All Sites
Customize:

RE: Thanks Brett for the answer - yes it sounds a tricky one, as the set up of the code...

Started 3 weeks ago (2009-12-01 05:09:00) by dwill

Thanks Brett for the answer - yes it sounds a tricky one, as the set up of the code is that I don't have access to the insert code (you are right it is not stored procedures) but I do have access to the output code. In short I am doing the reporting side of things and the data capture is offshore - no support contract to worry about but lifecycles of development and change requests mean ...

Source: dBforums - Database Support Community

Forum: Microsoft SQL Server

Thread: Show this thread (7 posts)

Size: 756 bytes
Related Threads: Same Site | All Sites
Customize:

RE: Maybe Access doesn't use stored procedures, even if I define them, in fact, it translates the PROCEDURE statement with...

Started 2 months, 2 weeks ago (2009-10-07 09:05:00) by Luc484

Maybe Access doesn't use stored procedures, even if I define them, in fact, it translates the PROCEDURE statement with the PARAMETERS statement. Anyway, I'm able to use the results of a query in another query, for instance (call this query2): Code: SELECT COUNT(*) FROM query1; given query1 is defined, for instance as: Code: SELECT * FROM table1 WHERE table1.field1...

Source: dBforums - Database Support Community

Forum: Microsoft Access

Thread: Show this thread (11 posts)

Size: 1,877 bytes
Related Threads: Same Site | All Sites
Customize:

Re: Cannot access Stored Procedures in LINQ

Started 3 months ago (2009-09-21 04:09:00) by imanewbe

I figured it out thanks to the tutorial. Thanks abhijeet_dighe.

Source: Forums - ASP.NET Forums

Forum: Data Access and ObjectDataSource Control

Thread: Show this thread (5 posts)

Size: 165 bytes
Related Threads: Same Site | All Sites
Customize:

stored procedures in access | Topic profile

Posting activity graph on stored procedures in access:

stored procedures in access was discussed on the following sites:

Related topics:

Latest threads on stored procedures in access:

Hot threads on stored procedures in access: