Environ("home") through Citrix NFuse

  • Thread starter Thread starter TBernard
  • Start date Start date
T

TBernard

We have a dial-in system here at work named Citrix NFuse.
It works great for us, but I have come across one error.
The Environ("home") code does not work on any MS Access
database when they are accessed through Citrix NFuse. If
I run the exact same procedure though the database by
opening it through the Network Neighborhood it works just
fine. But if I try to run the procedure with the code
Environ("home") through Citrix NFuse I get a "".

I don't know if there is a work around for this, or if
anyone has run into this error before, or if anyone is
familiar with Citrix NFuse. I have gotten alot of great
help from this message board, so I felt it was worth a
shot.

Thank you for your time,

TBernard
 
TBernard said:
We have a dial-in system here at work named Citrix NFuse.
It works great for us, but I have come across one error.
The Environ("home") code does not work on any MS Access
database when they are accessed through Citrix NFuse. If
I run the exact same procedure though the database by
opening it through the Network Neighborhood it works just
fine. But if I try to run the procedure with the code
Environ("home") through Citrix NFuse I get a "".

I don't know if there is a work around for this, or if
anyone has run into this error before, or if anyone is
familiar with Citrix NFuse. I have gotten alot of great
help from this message board, so I felt it was worth a
shot.

Thank you for your time,

TBernard
Click to expand...

I don't know anything about NFuse, and not much about Citrix, but I
gather it's a terminal-server arrangement. As such, Access is not
actually running on the user's local computer at all, and I wouldn't
expect the local user's environment settings to be returned by the
Environ() function in that situation. Rather, I'd expect the server's
environment settings to be returned, or at least those that have been
set up on the server for this particular logged-in user's session.
Could this be your problem?

I don't know what what your code is doing with the "home" environment
string -- this must be something that is meaningful to your local
installation, but your reference to the 'Environ("home") code' means
nothing to me.
 
Thank you for your help Dirk, it puts me on the right
path. Do you know how to retrieve the server environment
settings through VBA coding in an MS Access DB?

Again thank you,

TBernard
 
-----Original Message-----
Thank you for your help Dirk, it puts me on the right
path. Do you know how to retrieve the server environment
settings through VBA coding in an MS Access DB?

Again thank you,

TBernard
.
Click to expand...

I actually stumbled across a fix for this.

I changed my code from Environ("Home") to Environ
("Username")

Thank you for your help and time.

TBernard
 
TBernard said:
I actually stumbled across a fix for this.

I changed my code from Environ("Home") to Environ
("Username")

Thank you for your help and time.
Click to expand...

Great! You're welcome.
 
Back
Top