05-30-2002, 03:56 AM
Is it correct that MSDE is much faster than JET4 ?
I've got an application we have written using JET4.
We are producing a SQL2000 version and want to decide if to convert the JET4 into MSDE and abandon JET4 all together.
Where do I get MSDE from ? I can't find anything about it on Microsoft product pages. Does it come bundled with something else ?
05-30-2002, 04:29 AM
MSDE is the free limited version of SQL server which comes with Office Professional and Visual Basic/Studio Professional.
You can download it on the Microsoft website (http://msdn.microsoft.com/vstudio/downloads/addins/msde/default.asp)
Jet 4.0 is the ADO driver for using Access 2000 and up files and has nothing to do with SQL server or any other database server.
05-30-2002, 08:24 AM
As Arnout pointed out, when you use Jet, there is no actual
database server. This makes multiuser concurency problems
much harder to deal with. MSDE is ideal for a small setup because
it exactly duplicates SQL Server, so upgrading to SQL Server is
totally painless. You can even disconnect a database from MSDE,
and reconnect it to SQL Server, and use Enterprise Manager in
SQL Server to maintenance a linked MSDE server.
05-30-2002, 02:58 PM
About the only differences between MSDE and SQL Server 2K is that MSDE is limited in the number of concurrent users, and the database size is limited to 2 GByte. Also, MSDE doesn't come with any any front-end administration tools. If you are interested, I posted a simple Admin Tool (http://www.visualbasicforum.com/showthread.php?s=&threadid=26074) for MDSE in the Code Library a while back.
05-30-2002, 03:12 PM
The downloadable version of MSDE doesn't come with the Enterprise tools. However, the version you can order from MS (not free, but quite cheap, about 8 USD) does come with them.