Maximum instances of Access 2000 on one server

T

truppert

I'm looking to find out how many Access 2000 instances can safely run on one
server class system running Citrix on the front end and talking to a back end
SQL 2000 database on a separate server. Thanks, Tim.
 
A

Albert D. Kallal

There is little, or no limit at all here. The only thing you need to ensure
is that you DO NOT ALLOW multiple users into a single instance of the front
end (and, by the way, that front end is a mde..right????).

Assuming you got the correct setup..then the only limits here is going to be
the horsepower of the server it self, and how many users it can support. If
your server can support 200 users..then you can easily run 200 ms-access
sessions (ms-access is only loaded once in this case!). However, while
ms-access has what is called re-entrant code...a front end does not, and
problems occur when you don't give each user their own copy of the front end
(and, it should be mde).

So, as long as you DO NOT allow multiple users into your front end, and EACH
USER that logs on GET THEIR OWN COPY of the front end..then your limits are
only that of your server.

If you allow multiple users into the same copy of the front end...you will
have nothing but problems.....
 
V

Van T. Dinh

It depends on the diferent licenses you have:

1. With SQL Server 2000 software, you can either have "per CPU" license or
"per seat" license. "Per CPU" license does not limit the number of users but
"per seat" will up to the number of SQL Server Client Access licenses you
have.

1. You will also be limited to the number of Windows Terminal Server Client
Access licenses you have. Note that clients who use Windows XP don't need
the Windows Terminal Server Client Access licenses as Windows XP comes with
its own.

2. You will also be limited to the number of Citrix Client licenses you
have.

Assuming hardware is not the problem, you will be limited to the min. of the
above 3.
 
Top