>Okay George, I am writing a Broker System for a client. Now I'm thinking of doing this thing general purpose where it can be re-sold.
>
>So the issues are
>1. Deployment
>2. Scalability
>3. Connectivity (Client/Server)
>4. Speed
>
>There are about 20 Users.
>
>I'm used to SQl Server 6.5. When I installed MSDE I don't see any interface or anything, just a screen where i can start the server.
>
>1. I don't see where I can manage a database; be it creating one or otherwise.
>
>
>I'm try it out on my personal computer with Win 98.
>
>I'm a bit confused about this thing works. HELP ????
>
>Chris
I'd like to add a couple of things to Éric's response.
MSDE allows you to scale easily to SQL Server. There are other thing to consider to ensure your app is scaleable. One other is to ensure that your app is modular. Separate your app into tiers. Do not allow your UI to talk directly to your database, use business classes to be the intermediaries. Process all your business rules in these classes. So if later you need to change the UI to IE of something else, or if you need to make changes to any part of your app it is not a major chore. There are several other advantages I could go into but my point is that you should start out with a solid approach. More work up front but pays itself back very well later.
George