MSDE -v- JET4 and SQL2000

05-30-2002, 02: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, 03: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 (

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, 07: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, 01: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 ( for MDSE in the Code Library a while back.

05-30-2002, 02: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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum