Stored Procedure as RecordSource does not work in Access 2002

B

Brad Naugle

I have an Access Data Project that has form that uses a
stored procedure as it's record source. This is all set
dynamically through code as shown below:

Me.RecordSource = "dbo.proc_frm_Input"
Me.UniqueTable = "tblRequest"
Me.InputParameters = "@lngStartRqstId = Forms!frmMainMenu!
txbStartRqstId, @lngEndRqstId = Forms!frmMainMenu!
txbEndRqstId"

This code worked on when I was running the ADP on a
Windows XP Pro workstation with Office 2000. We are
upgrading to Office 2002 (XP). When I run the ADP with
Office 2002 the form does not appear to bring any data
back and if I set the .AllowAdditions = False for viewing
purposes all of the controls are not displayed on the
form.

Thanks in advance for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top