Access adp and Stored Procedures Running under Citrix

[ibethea]

Hi,
Problem: Access 2000 .adp SQL stored procedure problem using citrix

In my Access 2000 .adp application running under citrix, I am not able to successfully run any store procedures within the applcation. Where there are form objects dependent upon store procedure to populate them (i.e. dropdown boxes, subforms, main forms, etc...)these form objects return blank results.

While on citrix, I went into MS Access design mode and found that all of my stored procedure names had been changed (i.e. from "usp_getProject" to "usp_getProject;1&quot. This is the reason why my application would not function properly where stored procedures where involved. It could not find the correct stored procedure name. As a note, this name change does not occur with any other adp SQL objects such as views.

Any suggests? I've written scores of stored procedures in the application. I have even tried to pass the access forms SQL statements with parameters as objects to recordset or recordsource as a work around, without success.

 

[CitrixEngineer]

So you're saying that this doesn't work under Terminal Services either? I'd guess so, because what you are seeing is the result of Terminal Services session tagging - that is where the ;1 comes from: When a user starts a session on a Terminal server, they get a complete copy of the operating system, and any process run inside that copy O/S (including the O/S processes) gets a tag to differentiate it from the same process being run by another user.

I'm not a programmer, but there must be a way to put a container in the place of that tag as a variable - eg "usp_getProject;[var]". What it is, I couldn't say - but some of the programming forums might know.

Good Luck!

CitrixEngineer@yahoo.co.uk