To access the data you must actually import the data into Microsoft Access or connect to the source directly.Top You can open a project in Project 2003 that was previously saved to a database using either Microsoft Project 98, Microsoft Project 2000, or Microsoft Project 2002.Top The normal, standard procedures for SQL Server database performance and tuning apply to Project databases.
These modifications are preserved if they do not cause one of the above listed conditions.
When adding new rows, EXT_EDIT_REF_DATA must be set to the value 1.
It is recommended that enterprise project data in the Project Server database only be interacted with by using the Project Data Service (PDS), Microsoft Office Project Professional B 2003, or Microsoft Office Project Web Access 2003.
The advantages of creating and maintaining project data directly in the database include: Note BBThe script creates the database tables described in this document.
To prevent errors in changed task, resource, assignment, and link (task dependency) data from causing inconsistencies in the Project database, the original data should be backed up in the respective EXT_EDIT_REF_DATA columns of the MSP_TASKS, MSP_RESOURCES, MSP_ASSIGNMENTS, and MSP_LINKS tables.
Project uses this data to help determine which columns have been modified in the database.
The following actions could corrupt a project stored in a database: Project verifies some data when reading a project from a database, or any other external format.
The following cases may cause Project to display an alert, change data to an appropriate value, or not read the data at all: Note BBThe original data is restored if any changed data contains errors that Project can't reconcile.
Each database user can only see one set of project tables in a given database because Project uses the first set of tables it finds in the database.