MS Project Memory Leaks

[Patrick]

Hi,

I noticed a post on here for a similar problem, but there had been no
reply and the post was quite old.

Please could someone see if they can help me out? Where I work we
maintain close to 3000 project plans, the data of which gets uploaded
to an Access Database in one hit each week - not my preferred method of
working, but we have to continue what someone else started.

The macro written to achieve this does the following:

Opens Plan
Maps Data
Exports Data
Closes Plan

However, doing this, it does not take long for the memory to peak, and
after about an hour, and 2000 plans, the memory runs out and the
program crashes.

Does anyone know how I can fix this? I can post the code if required...
I find it very difficult to find anywhere on the internet that provides
Microsoft Project support.

Thanks

Patrick

 

[Rod Gill]

By the sounds of it, you aren't exporting all Access data?

If you want all data exported, the simpler way rather than mapping is to
File, Save as to access. the projdb.htm file in one of Project's program
folders describes the data structure.

Alternatively, copy paste the macro to Access and run it from there. Some
things will need editing, but basically it's not a major to move. I would
have one table that has a record for all project level data including a
hyperlink to the .mpp file. This is how your modified macro would find the
mpp file to open it.

By keeping a count you could close Project every 100 projects to make sure
any Memory leaks from Project were eliminated.

 

[Patrick]

Hi Rod,

Thanks for your reply. Your suggestions are very intriguing.

Firstly, we don't need all the information from the plan, just certain
fields, so I am not sure that exporting the whole plan is the solution.

However, I like your suggestion about importing from access into one
table, as opposed to exporting from Project, with each plan becoming a
table. We have a master table which is populated by extracting all the
data from the individual tables, and it appears your suggestion would
eliminate this step and go straight to the master table. Is that right?

I am relatively new to the world of vba, and although my understanding
of Project is good, it is not good enough to know how to extract data
from a project plan programmatically, without using mapedit.

Could you briefly explain how you would select the data you require,
and import it into an access database table?

Thanks loads for your help so far, I look forward to your (or anyone
elses) reply.

Patrick