>I went to MS site and found this:
>
>

Q: Can MSDE databases serve multiple users?

>A: MSDE is tuned for desktop and shared solutions where there are less than 5 concurrent users hitting the database at any one time. SQL Server Desktop also shares this optimization at five concurrent users or less. If your solution needs to support more than this number of concurrent users, we highly recommend you migrate to SQL Server or SQL Server Enterprise editions for optimal performance at this higher level of scalabily.

>
>Does this mean that you can't use it for more than 5 users at a time or that performance will decress? MS also said that ADO will sometimes open up two connection when doing a query for faster results and close them when the query is done. So if ADO opened up a second connection will I get an error or poor performance?

No, you can have 1000 users (well it may not allow that many connections.) but only have 5 queries happening togther.

BOb