Connecting Oracle/MS Resource Pool (Non server based)

V

VSAT Ryan

I am looking to create a resource pool that can be shared amongst programs.
The main goal is to provide PM's a file that allows them to access any
resource. Seeing resource availability is not a priority, but I am sure
comes with the territory.

As our company grows, I would rather not maintain this resource pool by
adding individual names for each new hire. HR does take care of all that in
our Oracle system. Is there anyway that a resource pool can be
dynamically/live linked to an Oracle table, such that the latest information
is retrieved when resource pool file is opened?

Thanks!
 
R

Rod Gill

The only way I know of is by using a Project VBA macro to read data directly
from Oracle. If you are going to do that then I would not use a resource
pool but have a Macro show a form with all departments. Clicking on a
department shows all resources in it for the PM to select. The resource
would then be added to the project. Using a resource pool just to show all
resources adds complications, slower performance and risks of corruption if
file names get changed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project 2003 Resource Pool link issue 1
Resource Pool: MSP wants to & does open multiple simultaneous copi 3
Resource Pool Links 1
How to avoid overstated costs with a shared resource pool 1
can not link projects to resource pool 0
Resource Pool Size & Clean Up 1
Resource Pool links - Company's server change caused problems 2
Allocation using a resource pool 3

Top