Access your Access files in Microsoft Project

 Jul 22, 2014

As mentioned in my previous blog posts (3 settings that will increase your efficiency in Microsoft ProjectAutomatically reach your deadlines with scheduled tasks in Microsoft Project), a Microsoft Project user must configure some global settings in Microsoft Project 2010 and 2013 in order to be more efficient and to take full advantage of the improved features of the application.

Another great feature I find very useful and will discuss in today's post is Microsoft Project's ability to import Access database files. Microsoft Project allows users to collaborate with others and delegate project files to others who do not have Project installed or do not know how to use the application. These files can contain resource information, task information or assignment information.

When you first try to import a Microsoft Access database file into Project, the following dialogue box will appear:

Access your Access files in Microsoft Project

To allow Access databases to be imported, you have to make the following changes in the Project settings:

  1. Open a blank Microsoft Project file.
  2. Click the 'File' tab and select 'Options.' The Project Options dialogue box will appear.
  3. In this dialogue box, click the 'Trust Center' tab in the left-hand side navigation pane. Access your Access files in Microsoft Project
  4. Click the 'Trust Center Settings' button on the right hand side. Another dialogue box will appear.
  5. Select the 'Legacy Formats' option and tick the 'Allow loading files with legacy or non-default file formats' option. Access your Access files in Microsoft Project
  6. Click 'OK' to save the changes and click 'OK' again to close the Project Options dialogue box.

Now, you're all set up to import https://nhaustralia.com.au/files/blog/a microsoft access database resources list into a microsoft project file. in a future blog post, i'll explain the method to import a Microsoft Access database resources list into a Microsoft Project file, so stay tuned!

How do your Excel skills stack up?   

Test Now  

About the Author:

Magdalena Todor  

With over 20 years experience as a facilitator and university lecturer, Magda is one of our most senior and experienced trainers. With previous practical on the job experience as a project manager she embodies a brilliant balance of training experience and business knowledge. With every event she delivers, Magda takes a wholehearted approach to ensure every course is impactful, relevant and a genuinely positive learning experience for all.

Read full bio
top