Replies

Hi,

Do you have your subprojects linked in dependency relationships to each other? If not you will not see the critical path of the Master file. You will probably just see an assortment of critical task strings.

Carla

Ok, I have found the problem. Current Status is a field that comes from a subquery. Not only did I have a quote problem, I also needed an AND condition. Thank you so much for restarting my thinking. I have spent way too much time on apparently being brain dead today.
Carla

Ok, I have found the problem. Current Status is a field that comes from a subquery. Not only did I have a quote problem, I also needed an AND condition. Thank you so much for restarting my thinking. I have spent way too much time on apparently being brain dead today.
Carla

Hi Hans,

The line you sent does not return a type mismatch, but it also returns the entire set of records.
stLinkCriteria = “[Current Status] “”Withdrawn””” This line will eliminate Withdrawn
stLinkCriteria = “[Current Status] “”Exempt””” This line will eliminate Exempt
Any other ideas?

Thank you again for your help
Carla

Hi Hans,

The line you sent does not return a type mismatch, but it also returns the entire set of records.
stLinkCriteria = “[Current Status] “”Withdrawn””” This line will eliminate Withdrawn
stLinkCriteria = “[Current Status] “”Exempt””” This line will eliminate Exempt
Any other ideas?

Thank you again for your help
Carla

Hi Wendell,

Sorry it took me so long to get back, I have been out of the office for a couple of days

Thank you for confirming what I probably already knew about exporting objects one at a time. I was looking for an easier way. What I have decided to do is use a 2G USB drive and just take all the files for the 4 main databases to my home PC in their entirety. I have a Word document with all the target strings for the shortcuts for local C drive security file locations and network security file locations so I can just copy and paste them into the shortcuts when I change the physical locations of the databases. I created the Word document a few months ago so I could continue development work on my local PC if the network where the security files are stored went down easily. Not a very elegant solution, but it will be a reasonable solution.
Thank you for the suggestions and information.
Carla

Hi Wendell,

Sorry it took me so long to get back, I have been out of the office for a couple of days

Thank you for confirming what I probably already knew about exporting objects one at a time. I was looking for an easier way. What I have decided to do is use a 2G USB drive and just take all the files for the 4 main databases to my home PC in their entirety. I have a Word document with all the target strings for the shortcuts for local C drive security file locations and network security file locations so I can just copy and paste them into the shortcuts when I change the physical locations of the databases. I created the Word document a few months ago so I could continue development work on my local PC if the network where the security files are stored went down easily. Not a very elegant solution, but it will be a reasonable solution.
Thank you for the suggestions and information.
Carla

Hi Alice,
If you change the schedule to match actuals then you will defeat the purpose of tracking acutals against schedule. I guess you could, if you had captured the schedule into a baseline but what would be the purpose of doing the same work twice? I use the tracking table to record actual start or finish entered manually if they do not match the schedule. Another more detailed way to track actual work is to use the Task Usage view, right click in the column called Details where the work entry is repeated and add actual work. This allows you to update actual work per day per resource.

Because of the default effort driven scheduling Project uses I have found using Actual Duration and Remaining Duration to update the plan brings some unexpected results. I would recommend against using either field for updating. In the alternative use one of the above methods.

What happens to the rest of the schedule when you have a later Actual Finish is dependent on if the successor task is marked as complete or is still in the active part of the project. If the successor task is complete then the later actual finish will just be updated. If the successor task is in the active part of the project ( not marked as any percent complete) and is on the critical path the project finish date will move out correspondingly.

Remember when entering an actual finish date it implies end of business on that day. If you are using sequentially linked tasks and they are spanning half days you will get a half day slippage if you only enter the date. You can get a half day by entering something like 1/15/2004 12:00 PM.

Hope this clears up some things, again this is certainly not the only way, just some strategies that have worked well for me.
Carla

Hi Alice,
If you change the schedule to match actuals then you will defeat the purpose of tracking acutals against schedule. I guess you could, if you had captured the schedule into a baseline but what would be the purpose of doing the same work twice? I use the tracking table to record actual start or finish entered manually if they do not match the schedule. Another more detailed way to track actual work is to use the Task Usage view, right click in the column called Details where the work entry is repeated and add actual work. This allows you to update actual work per day per resource.

Because of the default effort driven scheduling Project uses I have found using Actual Duration and Remaining Duration to update the plan brings some unexpected results. I would recommend against using either field for updating. In the alternative use one of the above methods.

What happens to the rest of the schedule when you have a later Actual Finish is dependent on if the successor task is marked as complete or is still in the active part of the project. If the successor task is complete then the later actual finish will just be updated. If the successor task is in the active part of the project ( not marked as any percent complete) and is on the critical path the project finish date will move out correspondingly.

Remember when entering an actual finish date it implies end of business on that day. If you are using sequentially linked tasks and they are spanning half days you will get a half day slippage if you only enter the date. You can get a half day by entering something like 1/15/2004 12:00 PM.

Hope this clears up some things, again this is certainly not the only way, just some strategies that have worked well for me.
Carla

(Edited by HansV to make URL and reference to post clickable – see Help 19)

Have you tried using jetcomp? It is a free product. I saw it recommended in the lounge and I used it on a corrupt database a few months ago and was able to recover it.
See post 404706 or

Recommend see MSKB 273956:

http://support.microsoft.com/default.aspx?…amp;Product=acc%5B/url%5D

Carla

(Edited by HansV to make URL and reference to post clickable – see Help 19)

Have you tried using jetcomp? It is a free product. I saw it recommended in the lounge and I used it on a corrupt database a few months ago and was able to recover it.
See post 404706 or

Recommend see MSKB 273956:

http://support.microsoft.com/default.aspx?…amp;Product=acc%5B/url%5D

Carla

I am not sure what the technical use of the tagged process is but I saw a diagram where the tag corner was used to number steps in a business process. You have the ability to add text to just the to the corner tag by selecting the corner(you will see the locks surrounding the corner) then adding text. Since the corner is black and the default font color is black you will need to make a color adjustment.

Carla

I am not sure what the technical use of the tagged process is but I saw a diagram where the tag corner was used to number steps in a business process. You have the ability to add text to just the to the corner tag by selecting the corner(you will see the locks surrounding the corner) then adding text. Since the corner is black and the default font color is black you will need to make a color adjustment.

Carla

Hi Again,

By joining the workgroup in the new database container I was able to import the all of the objects except the action queries, which is progress. I could export the queries individually, but this still leaves me with a secured copy. I have in the past gone through the process detailed in the Microsoft knowledge base to extract a database out of the security scenario without any success. The only way I have been able to accomplish this is by exporting each object one at a time. My hope is that ther is an easier way that I am not aware of. I have looked at the link one of the Access moderators provided for securing an Access database and it was a lot of great information, but not much on how to get a database out of the security.
Again thank you for your suggestion.
Carla

Hi Again,

By joining the workgroup in the new database container I was able to import the all of the objects except the action queries, which is progress. I could export the queries individually, but this still leaves me with a secured copy. I have in the past gone through the process detailed in the Microsoft knowledge base to extract a database out of the security scenario without any success. The only way I have been able to accomplish this is by exporting each object one at a time. My hope is that ther is an easier way that I am not aware of. I have looked at the link one of the Access moderators provided for securing an Access database and it was a lot of great information, but not much on how to get a database out of the security.
Again thank you for your suggestion.
Carla