>I just read the MS info about MSDE.
>Is this something we should have a look on, as fox developper?

Here are some quotes from:

http://msdn.microsoft.com/isapi/msdnlib.idc?theURL=/library/backgrnd/html/msdeforvs.htm&RLD=462


Jet

Jet can support up to 255 concurrent users, but performance of the file-based architecture can prevent its use for many concurrent users. In general, it is best to use Jet for 10 or fewer concurrent users. Jet 4.0 now supports row-level locking.

MSDE

MSDE is tuned for best optimum performance at five concurrent users or less. MSDE can support more than five concurrent users both from a technical and licensing standpoint, but Microsoft strongly suggests that the number of concurrent users be five or less in order to enjoy the performance levels available with MSDE. MSDE also supports row-level locking.

SQL Server

SQL Server can support hundreds of concurrent users. Like Jet and MSDE, SQL Server also supports row-level locking.



Cost

MSDE is available to any licensed customer of Office 2000 Professional, 2000 Premium edition, or any Visual Studio 6.0 Enterprise or Professional edition tool, including:

Visual Studio 6.0, Professional and Enterprise editions.
Visual Basic 6.0, Professional and Enterprise editions.
Visual C++® 6.0, Professional and Enterprise editions.
Visual InterDev™ 6.0 Professional edition.
Visual J++® 6.0, Professional edition.
Visual FoxPro® 6.0 Professional edition.

Developers that build desktop and shared database solutions using MSDE may distribute their applications royalty-free, provided that the developer of an MSDE solution is licensed for the following products:

Microsoft Office 2000 Developer.
Any Microsoft Visual Studio 6.0 Professional or Enterprise tool (as listed above).

Jet databases are also freely distributable as the data engine for solutions built with Microsoft Office and Visual Studio development tools. However, desktop and shared database solutions built with Jet do not offer the clearest path to SQL Server. If cost is a limitation with your development effort, MSDE is the best choice.


[Peter again]

Anyone care to write a comparable concurrent user summary for VFP?


Peter