[AccessD] MS Access 2000 and Terminal Server 2K3

Sorry, I kept referencing an mde throughout that, it's an mdb I'm using as
you can't place an mde in design mode; other than that it's a graceful
solution.  If you need any more help just yell.

Cheers 
Tom


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

Thanks,

I like the idea of that solution.  I think I'll implement that and move 
away from my single copy.

Paul

At 03:35 AM 5/3/2005, you wrote:
>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
>
>


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