Citrix and Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Thanks, I will try that

John Vinson said:
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
Click to expand...

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]
Click to expand...
 
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

Chris Scheetz said:
Thanks, I will try that

John Vinson said:
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
Click to expand...

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]
Click to expand...
Click to expand...
 
Chris said:
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
Click to expand...

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.
 
Back
Top