Citrix and Access

[Guest]

We are running access on a Citrix Server. Several functions that work
perfectly on our SQL server don't work on Citrix. For example, the built in
function RIGHT gives the following error "function is not available in
expressions in query expression Right([srp_eventdate[,11)". Citrix server is
running Office service pack 2.
Any clues to how I can fix this?
Thanks
Chris

 

[John Vinson]

We are running access on a Citrix Server. Several functions that work
perfectly on our SQL server don't work on Citrix. For example, the built in
function RIGHT gives the following error "function is not available in
expressions in query expression Right([srp_eventdate[,11)". Citrix server is
running Office service pack 2.
Any clues to how I can fix this?
Thanks
Chris

Sounds like you're missing some References. Open the VBA editor and
select Tools... References; if any are marked MISSING, you'll have
this symptom.

Either uncheck and recheck the missing reference to force Access to
relink it; or, if that doesn't work, make sure that the server running
Access in fact has the needed .dll installed.

John W. Vinson[MVP]

 

[Guest]

Thanks, I will try that

We are running access on a Citrix Server. Several functions that work
perfectly on our SQL server don't work on Citrix. For example, the built in
function RIGHT gives the following error "function is not available in
expressions in query expression Right([srp_eventdate[,11)". Citrix server is
running Office service pack 2.
Any clues to how I can fix this?
Thanks
Chris

Sounds like you're missing some References. Open the VBA editor and
select Tools... References; if any are marked MISSING, you'll have
this symptom.

Either uncheck and recheck the missing reference to force Access to
relink it; or, if that doesn't work, make sure that the server running
Access in fact has the needed .dll installed.

John W. Vinson[MVP]

 

[Guest]

Hi John,
I don't have anything marked as missing. Do you know which .dll files I
should look for and where they are typically located?
Thanks

Thanks, I will try that

We are running access on a Citrix Server. Several functions that work
perfectly on our SQL server don't work on Citrix. For example, the built in
function RIGHT gives the following error "function is not available in
expressions in query expression Right([srp_eventdate[,11)". Citrix server is
running Office service pack 2.
Any clues to how I can fix this?
Thanks
Chris

Sounds like you're missing some References. Open the VBA editor and
select Tools... References; if any are marked MISSING, you'll have
this symptom.

Either uncheck and recheck the missing reference to force Access to
relink it; or, if that doesn't work, make sure that the server running
Access in fact has the needed .dll installed.

John W. Vinson[MVP]

 

[Rick Brandt]

Hi John,
I don't have anything marked as missing. Do you know which .dll
files I should look for and where they are typically located?
Thanks

Did you do this check while opening the file ON the Citrix server? By that
I mean the actual instance of Access has to be opened on the Citrix Server
and then the file and then the references checked. A referecne that is
marked MISSING on the server might look fine on another box.

 

[Guest]

Yes I did have the file open while logged onto the Citrix server
Thanks