Connecting a MS Access Database to MS Project
Posted on 2008-10-15
I know in MS Project 2003 one could save a Project file as an Access database; however, it seems that Microsoft removed this option in Project 2007. I had some one on my Project team create a Project to Access relationship using 2003, but even then when I opened the files they were no longer linked to one another.
My question is, how can I connect MS Project 2007 to an Access 2007 database?
We have 1500 users we need to get trained on a new version of CATIA, and each user needs to take about 15 classes, and each class only supports up to 12 people. Out of the 1500 employees, there are about 20 varying training tracks, which includes around a total of 60 different classes, and a final total of about 700 classes we need to schedule. Needless to say our Project file is at around 3500 lines right now, and I'm guessing around 15000 instances of the resources...
This is not manageable in Project as is; we want to keep the tasks in Project, and move the resources to Access or SQL Server so the focals can manage the data via a web front-end, but I have not been successful in getting Project 2007 to talk to Access 2007...
Thanks in advance for the help, Jon
p.s. We needed a solution to this problem like yesterday, and while I know I could simply install the Office 2003 system, I figured I would ask the Experts first, before I revert back to a time without the Ribbon :)
p.s.s. We are currently using MOSS v2, but we are moving to MOSS v3 next month, so I am interested in possible solutions there two, as long as they include me keeping Office 2007 installed :)