User Interference on terminal server (1 Viewer)

[MikeAngelastro]

Hi,

I have about 8 people using an Access frontend on a terminal server. It looks like they are interfering with one another in the use a temp table that is resident in the frontent. I did not expect this because I thought that each user of the terminal server has his/her own instance of the frontend in memory and would therefore not interfere with each other.

Does anyone have an explantion of or a solution to this behavior?

Thanks,

Mike

 

[RichMorrison]

Mike,

Yes each user has their own instance of the front end.

***** But *****
the "instance" does not apply to any local tables.

If you want to use a private local table for each user, then the TS administrators have to set up a private folder for each user.

RichM

 

[MikeAngelastro]

I had thought about it some more and that's what I figured. At some point even if the table is in memory the changes to it have to be committed to the disk. The result is that someone else gets bumped.

Your excellent suggestion is what I had decided to do. We'll see how it works.

Thanks.