In my workplace, we have just upgraded to Windows 7, we have a roaming profile, so all the files that are in the Application Data folder are in a folder called "\username\redirect\Folders.." also in this is the ESRI folder that contains the .sde files for the database connections. We have teams that share generic mxd's and one problem that we have found is that when a user adds data from their database connection e.g.
and then saves it, when another user tries to open the mxd the data source is broken, as the 2nd user does not have access to JoeBloggs folder.
My solution is to create a new folder that everyone has access to, and place the .sde connections in that folder, but how do I make the Database connections node in ArcCatalog look at this new folder rather then the folder in AppData\ESRI\ArcCatalog.
Hopefully that makes sense.