Three Microsoft Project 2000 Database Performance Substantial changes have been made to the database capabilities in Microsoft Project 2000 that primarily focus on improving performance. The schema have been simplified, reducing 38 tables to 21.
Field names follow a standard naming convention and are unique across all tables.
By default, assignment time-phased data is stored as compressed binary data in the database. If a manager would rather have access to time-phased data in the database, it can be saved in expanded form using a much simpler structure, similar to what is seen in the Resource Usage or Task Usage view in Microsoft Project Central. Microsoft Access 2000 Oracle Server, version 8.0 server and client Microsoft SQL Server 7.0 Microsoft Project 2000 can also make the ODBC connection automatically when writing to and reading from Microsoft Access 2000 databases when users directly select Project Database or Microsoft Access Database as the file type in the File Open and File Save dialog boxes. All rights reserved.