Form using stored procedure does not work in Access Runtime

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: 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)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.reports)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: insert stored procedure
    ... The problem was in my stored procedure: in my second line I had "@categoryID ... varchar " => I removed "" and it works now. ... @shopID int, @categoryID varchar ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sum() txtField not working with stored procedure recordset
    ... What is the stored procedure? ... Do you have a field or control called "account balance" ?? ... This used to work when the recordsource was set to a full SELECT ... returns an Account Balance field and a text box in the data area of the ...
    (microsoft.public.access.forms)