1. What is the Number of Maximum Users that are allowed in these
   version of SQL 2000
   a. MSDE 2000 (6 Users?)
   b. Personal
   c. Standard

2. Is it true that VBNet when accessing to SQL 2000 will make apps
   connect only Up to 6 Maximum users only?(Got this a different
   Support Group)?

__________________
Proud To Be Pinoy

1) How many client connections does SQL Server 2000 support?

SQL Server 2000 supports 32,767 connections per instance. You can run 16 instances per node, so the maximum number of client connections per server node is 524,272. Note that unless you have SQL Server 2000 Enterprise Edition, you have to pay separately to use each of the 16 instances on one computer.

You can also take a look at this SQL Server Architecture - Maximum Capacity Specifications

Using MSDE 2000 in a Web Application - You can look for connection/user specific info under headings Understanding the Workload Governor and Connection Pooling


2) I dont think so, but not sure about that, so I can't answer that, may be someone knows better on that.

Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection