M
Mike Thomas
I have an Access 2003 mde app running on a Citrix server. It is used by 15+
users. The app is opened by a batch file which checks whether the app has
been updated, loads the new one if it has, etc.
Each user has their own folder with their own copy of the mde.
After doing the checking and the copying into the user's folder, the batch
file sets the user's folder as the current folder (eg cd x:\UserFolder1\),
then opens the mde app with the following line:
MyApp.mde
So far so good - 'mde' is assoc with Access, and the app opens.
I think there is a problem, though, in that in some cases the mde is opening
with the Access on the user's workstation, not on the Citrix server. I want
to explicitly use the Access on the server as follows:
"X:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "MyApp.mde"
This generates an error: "Access cannot find MyApp.mde". I think that
Access must be resetting the current folder to "X:\Program Files\Microsoft
Office\OFFICE11\", then has no way to find 'MyApp.mde' in the user's folder.
Is there a way to explicitly open the mde using the Access copy in the above
path, but still making sure the user is using the mde in their own folder
and working in their own folder? Users cannot share mde's because of temp
tables, etc.
Many thanks
Mike Thomas
users. The app is opened by a batch file which checks whether the app has
been updated, loads the new one if it has, etc.
Each user has their own folder with their own copy of the mde.
After doing the checking and the copying into the user's folder, the batch
file sets the user's folder as the current folder (eg cd x:\UserFolder1\),
then opens the mde app with the following line:
MyApp.mde
So far so good - 'mde' is assoc with Access, and the app opens.
I think there is a problem, though, in that in some cases the mde is opening
with the Access on the user's workstation, not on the Citrix server. I want
to explicitly use the Access on the server as follows:
"X:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "MyApp.mde"
This generates an error: "Access cannot find MyApp.mde". I think that
Access must be resetting the current folder to "X:\Program Files\Microsoft
Office\OFFICE11\", then has no way to find 'MyApp.mde' in the user's folder.
Is there a way to explicitly open the mde using the Access copy in the above
path, but still making sure the user is using the mde in their own folder
and working in their own folder? Users cannot share mde's because of temp
tables, etc.
Many thanks
Mike Thomas