Solved

Connecting a MS Access Database to MS Project

Posted on 2008-10-15
2
1,789 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
ID: 22730736
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
ID: 22842675
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

947 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

19 Experts available now in Live!

Get 1:1 Help Now