Opening Access off Citrix Server

[JJames]

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?

 

[Rick Brandt]

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?

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

 

[JJames]

Thanks for your help Rick.

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