AceProject Max User Account Delimma

I have been using AceProject project management system for years. First at LANDesk, and now at McCann Erickson. Though it is a great tool for managing projects and tasks, it’s user management system lacks a vital feature, cascade delete user. That is, delete the user along with all it’s assigned tasks, projects etc.

So after having make various request for this “feature” I have written my own sequel procedure to handle the re-assignment and deletion of user accounts. In a nutshell, this procedure will re-assign all relevant data to a new user account, then delete the actual user record from the database. This then allows you to actually take advantage of your licenses (in our case 50 for now.)

Hopefully this helps someone else that is hosting this application as it did me.

Ace Project User Migration Stored Procedure

Tags: , , , ,

One Response to “AceProject Max User Account Delimma”

  1. From users to fans - Go Ahead, Manage Says:

    […] rewarding gestures a user can make.Jason Skowronek has been using AceProject for a long time, and, as he explains on his blog, he needed to be able to reuse user licenses. For example, when someone leaves the company, he […]