I have several projects which are linked by shared resources and saved in a master project. Now I need to link the Master Project tables to an Access database in which I use the dates from certain activities from the Project files to use in Access reports. When I save the master Project as an Access database, I don't get any tables which detail the various activities. Same thing if I do a Link tables directly in the existing Access database. All I get in the task table are the Project file names. Any ideas what I'm doing wrong?
I get usable tables if I save each project to an individual Access database, but that's not going to be a good way to get them all linked. Is there another way to set up the Master Project? Mine was created by opening all linked files and saving the automatic master project to a new name.
I get usable tables if I save each project to an individual Access database, but that's not going to be a good way to get them all linked. Is there another way to set up the Master Project? Mine was created by opening all linked files and saving the automatic master project to a new name.