Re: Form using stored procedure does not work in Access Runtime

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

B> I am using a parameterised stored procedure as a recordsource of a form.
B> When the form is opened on a machine with full Access everything is
B> working fine. However on a machine with only the Access runtime the form
B> will not open.

Should be working. Any error messages?

Also, I would remove SET NOCOUNT ON. This is essentially select statement,
so why not to tell Access how many records are returned.

Vadim Rapp


.