> the MSDE is a 100% compatible with sql server. that means you can develop
> your application in ms-access along with the msde. Then, when the company
> rolls out your application to 1000 users, it will run fine, and be a
> reliable robust system that and large company would expect.
> So, basically for a cases where you develop an application that needs sql
> server, you can use the MSDE. The reverse is also true:
> You can take a large complex system, and install it in a small branch
> office with 4 or 5 users, and again not have to re-write the sql server
> software. Since the MSDE is included in the office cd, it is free.
> So, if you plan to upgrade, or write applications for sql server, the MSDE
> is a perfect solution.
> You can also use in ms-access what is called a ADP project. This kind of
> ms-access application MUST use sql server. If you don't use a ADP project,
> then you need to use the Enterprise Manger to set-up, and mange the sql
> server. Note that the Enterprise manager works equally well with the MSDE,
> or sql server.
> So, MSDE is simply a small light weight version of sql server. It is by
> design limited in performance, since it is free. The idea here is once you
> outgrow it's ability (about 5 or 8 users), then you can upgrade to the