Solved

Connecting a MS Access Database to MS Project

Posted on 2008-10-15
2
1,725 Views
Last Modified: 2013-11-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 :)
0
Comment
Question by:JBredensteiner
2 Comments
 
LVL 7

Accepted Solution

by:
shambalad earned 500 total points
Comment Utility
Check out the Project Server SDK:
http://www.microsoft.com/downloads/details.aspx?FamilyId=2672F6F9-7028-4B30-99A2-18CB1EED1ABE&displaylang=en

The documentation for the SDK is found here:
http://msdn.microsoft.com/en-us/library/bb251740.aspx

There is an excellent book available that explains and furnishes code for working with MS Project 2007 and other Office 2007 applications (as well as SQL Server): 'VBA Programming for Microsoft Office Project' (Versions 98 through 2007) by Rod Gill. You can find further details at the following web site:

https://www.projectserverbooks.com/

Todd
0
 

Author Comment

by:JBredensteiner
Comment Utility
Thank you for you help Shambalad...
We have decided to take a slightly different approach with this project, but I am still very interested in this subject, but I just don't have time to read through all of the links you provided right now.  So, instead of making you wait another month to get your points, I will go ahead and post them now, and followup with another question if I need to.
Thanks again, Jon
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now