[AccessD] MS Access 2000 and Terminal Server 2K3

Hi Paul

Sorry about the delay, was off Friday and yesterday getting some sunshine!

What we're doing at my place is giving each user a link to a batch file on
their TS desktop.  The .mde sits on a shared network drive and the batch
file copies the mde over to the user's personal folder each time, and then
opens that copied mde.  As far as the user is concerned, she/he is simply
opening the same database as every other user.

This prevents bloat by giving the user a fresh mde each time; it also makes
rolling out new mde's a lot easier as we just have to copy the new one to a
single location.

Other than the bloat, I think the only performance consideration comes down
to the old Access chestnut of concurrent users, i.e. the fewer the better -
the approach outlined above guarantees only one user per .mde.  The other
reason we took this route was due to locking issues:  in my mde, reports are
altered at runtime placing the mde in exclusive lock - obviously you only
want one user in the db doing this or all the others will be booted out.

HTH, any other questions gladly answered!!
Cheers
Tom



-----Original Message-----
From: Paul M. Jones [mailto:pjones at btl.net] 
Sent: 29 April 2005 18:03
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MS Access 2000 and Terminal Server 2K3

Thanks for the offer Tom.
My situation is such:  I have an A2K application that talks to a SQL Server 
database.  Currently I have one (1) .mde front end on a Windows 2K3 
Terminal server.  All TS users have a link to that .mde on their 
desktop.  I have been toying with the idea of placing a copy of the .mde 
file for each user to run independently.  Apart from the issue of the 
ability to update the .mde front end, do you know if there are any major 
issues of one approach over the next, particularly from a system 
performance standpoint?

Paul

At 02:12 AM 4/29/2005, you wrote:
>Hi Paul
>
>I'm just coming to the end of a big AXP on terminal services project - I've
>been up and down just about every road there is.  If you need help with
>anything specific just ask and I'll glady impart any info I've learned.
>
>Cheers
>Tom


----------------------------------------------------------------------------
------------------
Reality is the murder of a beautiful theory by a gang of ugly facts.
         Robert L. Glass 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------

The contents of this message and any attachments are the property of Donns Solicitors 
and are intended for the confidential use of the named recipient only.  They may be legally
 privileged and should not be communicated to, or relied upon, by any other party without 
our written consent.  If you are not the addressee, please notify us immediately so that we 
can make arrangements for its return.  You should not show this e-mail to any person or
 take copies as you may be committing a criminal or civil offence for which you may be
 liable.  The statement and opinions expressed in this e-mail message are those of the 
writer, and do not necessarily represent that of Donns Solicitors.  Although any files attached
 to this e-mail will have been checked with virus protection software prior to transmission, 
you should carry out your own virus check before opening any attachment.  
Donns Solicitors does not accept any liability for any damage or loss which may be caused 
by software viruses...