Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Connecting a MS Access Database to MS Project

Posted on 2008-10-15
2
Medium Priority
?
2,203 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:Jon Bredensteiner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
shambalad earned 2000 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:Jon Bredensteiner
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

610 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