Windows 2000 Server is the right solution for workgroup file, print, and communication servers. Learn about the powerful end-to-end management, reliability, and scalability features that provide the best foundation for integrating your business with the Internet.

Microsoft Access 2000 is a powerful relational database application that a desktop user can use to efficiently create and manipulate database systems. Access targets the desktop category and works best for individuals and workgroups managing megabytes of data. For multi-user access to the same database, Access uses file-server architecture, rather than client-server architecture. Access is included in the Professional and Developer Editions of Microsoft Office.

As a leader in the desktop database category, Microsoft® Access makes it easy for users to find and manage their data to make better business decisions. With strong integration with Microsoft Office, Access offers a similar appearance and functionality to that found in the popular Microsoft Word and Excel applications. For general business users, Access provides ease-of-use wizards throughout, such as the Database Wizard for getting up and running quickly, and the Simple Query Wizard for easily finding information from the data. More advanced users appreciate the power behind the Microsoft Visual Basic® for Applications programming language, programmable toolbars, and the freely distributable runtime version of Access available with the Office Developer Edition. The combination of ease-of-use and power in Access makes it the top choice among developers who frequently use Access as a front-end to SQL Server in a client-server scenario.

Access has two major components. The first contains an application development environment for Visual Basic for Applications programmers that include forms technology, reports and database administration. In addition, as mentioned earlier, there is also the User Interface (UI) common to both Access and the other Office applications.

The second component in Access, and the main topic of this paper, is the data engine. Before Access 2000, users and developers were using the Jet data engine, whether they knew it or not. In the next version, users and developers will be given a choice of data engines. They can continue with an improved version of the default Access data engine Jet 4.0, or MSDE, a new data engine option in Access 2000.

Microsoft SQL Server 2000 offers XML features specifically designed for Web and database developers. Web developers do not have to learn database programming to make use of SQL Server 2000 XML features because SQL Server 2000 supports standard XML constructs, such as XPath, to allow them to interact with the database. Similarly, database developers do not have to learn XML programming and can use the FOR XML clause to obtain XML query results and OPENXML to manipulate the XML data. Lastly, SQL Server 2000 provides a simple declarative mechanism, XML Views, to define schema mapping for business-to-business transactions.

The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.

This document is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AS TO THE INFORMATION IN THIS DOCUMENT.

Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in, or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, copyrights, or other intellectual property.

© 2000 Microsoft Corporation. All rights reserved.

MySQL AB is the company that develops, supports and markets the MySQL database server globally. Our mission is to make superior data management available and affordable for all, and to contribute to building the mission-critical high-volume systems and products of tomorrow. We have made our product available at zero price under the GNU General Public License (GPL), and we also sell it under a commercial license to those who do not wish to be bound by the terms of the GPL.

The MySQL database server embodies an ingenious software architecture that maximises speed and customisability. Extensive reuse of pieces of code within the software and an ambition to produce minimalistic but functionally rich features have resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the table handler makes it possible to run MySQL under strict transaction control or with ultrafast transactionless disk access, whichever is most appropriate for the situation.

Today MySQL is the most popular open source database server in the world with more than 2 million installations powering websites, datawarehouses, business applications, logging systems and more. Customers such as Yahoo! Finance, MP3.com, Motorola, NASA, Silicon Graphics, and Texas Instruments use the MySQL server in mission-critical applications.

The company was set up in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius who have worked together since the 80's. MySQL AB is the sole owner of the MySQL server source code, the MySQL trademark and the mysql.com domain worldwide. The company is privately held and without debt, and it is financed by venture capital since July 2001.

MySQL AB employs some 30 staff around the globe, and thousands more contribute to the success of MySQL by testing the software, integrating it into other software products, and writing about it.

MySQL AB has three main sources of revenue

1.) Online support and subscription services sold globally over the MySQL.com website to all users of the MySQL server.
2.) Sales of commercial MySQL licenses to users and developers of software products and of products that contain software.
3.) Franchise of MySQL products and services under the MySQL brand to value-added partners.

We provide our customers and partners with support services they can depend on, consulting services, training programs, and more. In addition, to relevant advertisers we sell advertising space on our website that has more than 10,000,000 page views per month (as of January 2001).

Search engines and directories we recommend:

English

German