Skip to content
ProjectControls.com
Microsoft Project

MS Project multi-project reporting through MS Access

In the Open Standard
Niek ZonneveldMember for 21 years 7 months
Created
3
4
0
Anyone out there with experience on using MS Access for multi-project reporting?

I need to run consolidated queries/reports on about 40 mpp’s (about 5Mb each) and would like to understand if using MS Access is good vehicle to achieve this.

Storing multiple mpp’s in a single mdb is fairly straightforward, but the things I’m typically after is: performance considerations, example templates, do’s and dont’s, etc. etc.

Thanks in advance,

Niek.
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1
    Niek,
    with 40 projects 5 Mb each, it would be much better to use MS Project Server.
    if you keep storing your projects in a MS Access database, try using Crystal Reports to build your reports.
    Alexandre
    Report
  2. 0
    Niek Zonneveld ·
    #2
    Thanks Alexandre,

    What are the advantages of using Crystal Reports instead of the standard MS Access reporting capabilities? Is that performance or feature related?

    Thanks (again).

    Niek.
    Report
  3. 0
    Alexandre Faulx-Briole ·
    #3
    Niek,
    I am not good at all with Access; Crystal Reports is extremly fast and has plenty of features; all my trainees (I am a freelance software instructor) who know Access are really impressed by the power and easyness of Crystal Reports.
    Alexandre
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?