[AccessD] Access and Remote Desktop

David,

It us not at all clear what is meant by "each user opened a MSACCESS.EXE 
file which would run their individual session."  That answer does not really 
respond to the main point of your question.

But you are playing with fire if the setup does not include provision for 
each user to have their own separate copy of the frontend application.  This 
is done either by installing separate copies of the frontend within each 
user profile.  Or by using a startup script which makes a copy of the 
frontend from a master copy on the server, every time a user runs the 
application.

Regards
Steve

-----Original Message----- 
From: David Emerson
Sent: Friday, December 17, 2010 7:39 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access and Remote Desktop

Team,

With one of my clients the users used Remote Desktop and Terminal
Server to access an AccessXP FE/SQL2000 BE on a server.  They had a
shortcut created in their profiles to open the database FE in
Access.  I asked the following question from the IT guy and received
the answer below:

Q) With the Access billing program shortcuts, did each user have
their own copy of the main prog in their profiles, or did they all
point to the same physical file on the server?  If it was the same
physical file, can you confirm if terminal server opened separate
instances of the programme for each user?

A) All users pointed to the same physical file on the server.  Each
user opened a MSACCESS.EXE file which would run their individual
session.  Typically one of the EXE programs would spin out of control
and kill the server - never mind!

Is the above set up likely to cause problems or could it have been
some other configuration issue that caused the server problem?

I have read about providing each user with their own copy of the
FE.  How are you setting up your systems to handle this (batch file
to automatically copy the FE when it updates, etc).  Any other issues
I need to be aware of.