>Are they kidding... I just went and read some info on MSDE, thinking it may work for some of our cusomers who wanted more security than .DFB tables offered, but were not quite ready for full blown SQL 7.0.
>
>Well, they state that it is optimized for FIVE (5) concurent users???? Are they kidding...??? I assume this means 5 users TOTAL, not, 5 users all requesting data at the same time?
>
>This smacks of putting developers in the position to move clients to SQL. Heck, they did it with Jet when, with more than 10 users, it just died... now that Jet has learned a few things from FoxPro and scales up to over 20 users fairly well, they must have noticed a reduction in SQL sales.
>
>What do you all think about this? What about the competition? Does Sybase Anywhere only support 5 people?
>
>BOb

You pretty much nailed things. Limitations were purposely added to MSDE to force users to SQL Server. There is also a 2 Gig table limitation. The rule of thumb is, Jet and MSDE have pretty much the same limitations.