?
Solved

Connecting a MS Access Database to MS Project

Posted on 2008-10-15
2
Medium Priority
?
2,129 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

771 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