[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