[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.


Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand