Form using stored procedure does not work in Access Runtime
- From: "Bonno" <bonno.hylkema@xxxxxxxxx>
- Date: Sun, 19 Aug 2007 16:02:49 +0200
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
.
- Follow-Ups:
- Re: Form using stored procedure does not work in Access Runtime
- From: Vadim Rapp
- Re: Form using stored procedure does not work in Access Runtime
- From: CyberDwarf
- Re: Form using stored procedure does not work in Access Runtime
- Prev by Date: Re: Combine record
- Next by Date: FK Constraint Violation upon INSERT
- Previous by thread: Microsoft SQL Server Migration Assistant for Access: hidden tables
- Next by thread: Re: Form using stored procedure does not work in Access Runtime
- Index(es):
Relevant Pages
|