Opening Access off Citrix Server

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

Guest

We have a number of Citrix servers such that when a user logs on, it is
unknown as to what server they will end up on. Access is installed on each
of the servers. I want to open an Access application that is on the network
from within another Access application. I can do this easily outside of
Citrix with the following code:
RetVal = Shell("C:\Program Files\Microsoft Office\Office\MSAccess.exe
F:\Word\Database\CommitteeDB\UpdateCommittee.mde", vbMaximizedFocus)
How can I do this within a Citrix environment, where I do not know which
server is being used to run Access?
 
JJames said:
We have a number of Citrix servers such that when a user logs on, it is
unknown as to what server they will end up on. Access is installed on each
of the servers. I want to open an Access application that is on the network
from within another Access application. I can do this easily outside of
Citrix with the following code:
RetVal = Shell("C:\Program Files\Microsoft Office\Office\MSAccess.exe
F:\Word\Database\CommitteeDB\UpdateCommittee.mde", vbMaximizedFocus)
How can I do this within a Citrix environment, where I do not know which
server is being used to run Access?
Click to expand...

How does the server being used affect the command? Is Access not installed in
the same locations? Is the path to the Word document any different? For the
latter you can specify UNC paths instead of mapped drive letters and then it
would be the same no matter which machine was opening it.

You can use code at the link below to call Access even if it is in different
install locations per machine...

http://www.mvps.org/access/api/api0018.htm
 
Thanks for your help Rick.

Rick Brandt said:
How does the server being used affect the command? Is Access not installed in
the same locations? Is the path to the Word document any different? For the
latter you can specify UNC paths instead of mapped drive letters and then it
would be the same no matter which machine was opening it.

You can use code at the link below to call Access even if it is in different
install locations per machine...

http://www.mvps.org/access/api/api0018.htm
Click to expand...
 
Back
Top