Form using stored procedure does not work in Access Runtime

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi there,

I am using a parameterised stored procedure as a recordsource of a form.
When the form is opened on a machine with full Access everything is working
fine. However on a machine with only the Access runtime the form will not
open. In both situations for the same SQL account. What can be wrong?

I am using an Access 2000 adp-form and SQL Server 2000.

The stored procedure looks like this:

ALTER PROCEDURE dbo.ProductsFiltered
@CategoryID int
AS
SET NOCOUNT ON
SELECT * FROM Products
WHERE CategoryID = @CategoryID
RETURN

The form properties looks like this:

Recordsource: dbo.ProductsFiltered
Inputparameters: @CategoryID=1

Has anybody have any ideas?

Thanks in advance,

Bonno Hylkema


.

Relevant Pages

  • Re: Access ADP Form and Stored Procedure as RecordSource Options
    ... Me.RecordSource property, to a second Stored Procedure, in code when ... the Search button was clicked and include all the Input Parameters ... from the search criteria the user would input. ... What I realized is you can't change the RecordSource from one Stored ...
    (microsoft.public.access.adp.sqlserver)
  • Access ADP Form and Stored Procedure as RecordSource
    ... Me.RecordSource property, to a second Stored Procedure, in code when ... the Search button was clicked and include all the Input Parameters ... from the search criteria the user would input. ... What I realized is you can't change the RecordSource from one Stored ...
    (microsoft.public.access.queries)
  • Access ADP Form and Stored Procedure as RecordSource Options
    ... Me.RecordSource property, to a second Stored Procedure, in code when ... the Search button was clicked and include all the Input Parameters ... from the search criteria the user would input. ... What I realized is you can't change the RecordSource from one Stored ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How to pass parameter to SQL condition?
    ... WHERE (CategoryID = @CategoryID) ... Then I created a form with this stored procedure as its recordsource. ... Private Sub cboTest_AfterUpdate ... > enter the supplier name, and this works fine (by using ...
    (microsoft.public.access.adp.sqlserver)
  • stored procedure syntax?
    ... The individual queries that make up this stored procedure work fine. ... DECLARE @SentByUserId AS INT ... DECLARE @CategoryId AS INT ... -- SET NOCOUNT ON added to prevent extra result sets from ...
    (microsoft.public.sqlserver.programming)