Need guidance in programming...

[pasvorto]

I have a user who is developing a scheduling application using Project 2003.
I have all my production data in a SQL Server 2000 database. I need the
Project data to be updated when the production data is updated. I figured out
how to connect to the SQL Server db. What I need is a good book, tutorial,
etc that can give me code examples of how I might make these two systems talk
in real time. I created a test project and saved it as a SQL Server db.
However, when I look at the data, I don't see anything that I can directly
map to the project. I can see the tasks in the task table, but I don't see
any of the "sub tasks" listed anywhere, much less the data that shows in the
Project Gantt view. If I can't figure out how to make this work, I will be
forced to write the whole scheduling system in VB6/SQL Server 2000. That
would be a lot of work.

 

[pasvorto]

OK. As a test, I saved the "whole project" as an ACCESS database. I went into
ACCESS to have a look around. I can't make a "map" between what I am seeing
on the Gantt chart and what I am seeing in the db. Is there anyone who wants
to make a few "consulting" bucks? If I can have the Project 2003 data stored
in an ACCESS db, I can do what I want, once I can dettermine where, exactly,
the data is stored.

 

[JackD]

Read the document titled Projdb.htm.
When you are finished read it a couple more times.
Note particularly the flags that need to be set in order for Project to
accept any changes you make to the database.
You can email me the cash.