Re: Stored Procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sat, 9 Apr 2005 18:56:24 +1000

Use a Pass-Through Query (in Access MDB) with the SQL

EXEC dbo.YourSP ...

to execute sp in the SQL Server.

--
HTH
Van T. Dinh
MVP (Access)

"deodev" <deodev@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD553306-8D5D-4D24-8EB0-9EBB6553DF9E@xxxxxxxxxxxxxxxx
> I have a stored procedure on the SQL server -
>
> I created a Access database linking some tables from the database on the
> server.
> How can I execute the stored procedure from Access.
>
> If I create the query in Access it either takes a long time or the ODBC
> timeout.
>
>
> --
> deodev

.

References:
- Stored Procedure
  - From: deodev

Prev by Date: Re: Generating appointment letters In Acces 2003
Next by Date: Re: two questions...urgent
Previous by thread: Stored Procedure
Next by thread: help with locating public code
Index(es):
- Date
- Thread

Relevant Pages

Re: Execute Persmission denied on object sp_OACreate
... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
(microsoft.public.sqlserver.security)
RE: exec sp_help_job user account rights
... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
(microsoft.public.sqlserver.security)
Re: SSIS - OLE DB Command - how to retrieve query results ???
... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
(microsoft.public.sqlserver.dts)
RE: xp_cmdshell, ownership chaining, sql 2000
... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
(microsoft.public.sqlserver.programming)
Re: 3 Simple Security SQL Statements
... Kalen Delaney, SQL Server MVP ... window and execute. ... Builds a list of text commands. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ...
(microsoft.public.sqlserver.security)