Running Access .adp under Citrix - Store Procedures work properly

[ibethea]

I am running an Access .adp which includes several stored procedures in combo boxes and form record sources.
The stored procedures accept form fields to determine which values to return within a combo box or form record source. Under citrix the combo boxes or forms do not return any values or record sources. The combo boxes and/or forms are blank.
Any Ideas?

The same .adp work fine when not running under citrix.

 

[Zirak]

I had an almost similar problem.
I solved it by calling the stored procedure in the dbo.SP_... . On the rowsource property of the form instead of just putting the name of the storedprocedure put a "dbo." firt.
Hope it works!

 

[cmmrfrds]

As Zirak suggests it is probably a permissions or database owner problem. If the database owner is not running the app then you need to prefix all objects with "dbo.". If you write/test the app as the dbo then you will be able to access the objects but your users will not since they are not the database owners. Always prefix your object with dbo. then you will not run into the problem.

Was the same person/logon used on citrix? If not then check the permissions for the logon id that was used.

 

[ibethea]

I always name the stored procedure with the "dbo." prefix; (i.e dbo.usp_ProjectStaff) is defined as the recordsource. It appears the citrix is not able to find the parameter need by the stored procedure. This parameter is a field on the main form, which gets passed to the stored procedure in the recordsource on a subform.