Understanding Project Ole Db Provider Data

Use Access to take advantage of the capabilities of the Project OLE DB Provider. After you use the Project OLE DB Provider to connect to a project file in Access, you can access OLE data stored in a Microsoft Project file. Use the Microsoft Project data to create custom reports or break out and manipulate specific pieces of data. You can use this data across a wide variety of data sources, including relational databases, spreadsheets, and the Internet.

Project Server uses an OLE DB add-on called OLE DB for Online Analytical Processing g

(OLAP). This allows Project Web Access to present data using Microsoft Office Web Pivot-Table and PivotChart reports.

There are many possibilities for using OLE technology with a Microsoft Project file. For example, you can use ActiveX Data Objects (ADO) to access specific fields in a Microsoft Project file using an OLE DB Provider.

For more information about using OLE DB, see Microsoft Access and Microsoft Office Excel 2003 online Help. You might also find Microsoft OLE DB 2.0 Programmer's Reference and Data Access SDK helpful. You can also visit www.msdn.microsoft.com. In the Search MSDN box, enter Choosing Your Data Access Strategy and then click Go. Under Technical Resources, click Choosing Your Data Access Strategy (OLE DB Technical Articles).

All the data you enter in your project plan can be exposed using the Project OLE DB Provider.

The presentation of this data can vary, depending on the application you use to expose it, but it will always break out into a consistent grouping of data.

The following tables are exposed by the Project OLE DB Provider:

Assignments. This table contains all assignment information in the project, including references to all related tasks and resources.

Availability. This table stores the amount of time, start date, and finish date for each time period that each resource is available to work. Each unique time period is stored as a separate row.

For example, suppose that a resource is available for 4 hours on Monday and all day Friday. In this case, there would be two rows for this resource: one for the time period on Monday and one for the time period on Friday. If the resource were only available for 2 hours in the morning and 2 hours at the end of the day on Monday, these two time periods would be divided into two separate rows as well.

If you want to know more about OLE DB, see "Working with External References" on page 932. You can also visit www.msdn.microsoft.com. In the Search MSDN box, enter What OLE Is Really About and then click Go. Under Technical Resources, click the link to this article.

FEATURE!

Calendar. These three tables store all calendar-related information, including the time periods covered by the calendars, whether a calendar is a working times calendar or a base calendar, and exceptions.

Cost Rates. This table stores the costs associated with resources and assignments.

Custom Field. These tables store date, duration, number, text, field, and flag information that has been customized. Some of this information is available only for enterprise projects.

Predecessors. This table links tasks to their predecessor tasks, including the amount of lead or lag time; the duration of the lead or lag time; and whether the task relationship is start-to-start, finish-to-start, start-to-finish, or finish-to-finish.

Project. This table stores all project-related information, including project-level settings available in the File, Properties and Tools, Options dialog boxes.

Resources. This table stores all information about each resource in the project.

Successors. This table links tasks to their successor tasks, including the amount of lead or lag time; the duration of the lead or lag time; and whether the task relationship is start-to-start, finish-to-start, start-to-finish, or finish-to-finish.

Tasks. This table stores all information about each task in the project.

Task Splits. These tables track the start and finish dates for a task that has been split. There is also a separate table for baseline task splits.

Timephased. These are 15 unique timephased tables, five each for assignments, resources, and tasks. Each table is broken down by minute, hour, day, week, and month.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment