using access on terminal server

[Roy Goldhammer]

Hello there

I have business which has sotware written in access.

the mdb file is stored on the server and any user that runs the access using
terminal server on each computer.

there are at least 100 users. and the access is working very slow.

i'm thinking about option of moving to use the file as local on each
computer instead of terminal server. The network performance isn't good on
the business (10mbps) and the mdb is using some activeX components of visual
studio and ect...

can someone give me an advice, should i trasfare to work on local access
instead of terminal server?

 

[bob]

1. Access works best in a front-end (local PC), back-end (network PC) mode.
Less than 10 concurrent users.

2. With less than 10 users, my experience is that Terminal Services works OK
also.

3. Once past 10 users start to think about using SQL server on the back-end.
255 is theoretical max but ~ 10 is a practical max.

Bob

 

[Roy Goldhammer]

whell bob:

the back-end is sql server.

my question is: today 100 users are using terminal server and i'm thinking
about improve the system by placing the mdb on each client pc computer.

that is quite hard to do due to things i've explained before.
so all i need to know, is there advantage to place the mde on local pc
instead of using terminal server?

 

[Brendan Reynolds]

There's probably no simple answer, Roy. The key is probably to establish
just where the existing bottle-necks lie. The network is an obvious
candidate, but there are many other possibilities, including the design of
the application and database, the server hardware, and what other demands
are being placed on the network and the servers. If the app is very
carefully designed to retrieve the minimum data necessary across the
network, and the database is carefully designed, with appropriate use of
indexes, then I suppose placing the front-end on the clients might reduce
network traffic. On the other hand, if the app is not so carefully designed,
then it is entirely possible that placing the front-end on the clients might
increase network traffic. I doubt that anyone who isn't intimately familiar
with your environment can predict the result.