• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

MSDE Upgraded

Microsoft Data Engine (MSDE) was introduced with Access 2000. It offered compatibility with Microsoft SQL Server 7.0 and was an alternative database engine to Microsoft Jet. With Access 2002, Microsoft has upgraded and changed the name of this powerful engine that it continues to offer at no charge as an extra bonus (although it is not part of a standard Access installation). Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the new name of the data engine that is completely compatible with SQL Server 2000. This enables users to easily create and modify SQL Server-compatible databases that can be seamlessly deployed on SQL Server 2000 without any modifications.

Because MSDE 2000 is based on the same data engine as SQL Server 2000, most Microsoft Access projects or client/server applications run on either version. This does not mean that the new engine has all the same tools as SQL Server 2000, however. Think of it as a slimmed-down version of SQL Server 2000. Unlike SQL Server 2000, MSDE 2000 has a 2-gigabyte database size limit (the same as Access); it doesn’t support Symmetrical Multiprocessing (SMP) on Windows 98 or later; and, when using transactional replication, it can’t be a replication publisher (although it can act as a replication subscriber).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint