I have a number of resources in PS 2007 which are listed as both Checked Out
and Inactive though when I attempt to force check them in, they are not
listed. I am unable to change them to active because they are checked out,
but unable to check them in because they are not.
cutting and pasting my response from another thread a few weeks ago:
http://groups.google.com/group/micr...aef870a56/6ccb68ba86441ecb#6ccb68ba86441ecbWe ran into a similar problem once. Try running this SQL script
against the Published database to list any checked out resources:
SELECT
RES_UID,
RES_NAME,
RES_CHECKOUTBY
FROM MSP_Resources
WHERE RES_CHECKOUTBY IS NOT NULL
In the results look at the RES_CHECKOUTBY field. In our case we saw a
resource with an entry like '00-000000-000' (That's from memory, so
not exact.)
If you have a resource in that state, you can then run this script to
check them back in:
UPDATE MSP_RESOURCES
SET RES_CHECKOUTBY = NULL
WHERE RES_UID = 'Put the res_UID from the above query here'
Of course, this is SQL to modify the Project databases directly. It's
like editing the registry: There is potential for great harm to the
system. Perform this on a test instance first; be careful; and I am
not liable for any use of this.
James Fraser
<<<
Hope it helps...
James Fraser
