I've just spent an hour trying to resolve a problem and thought I'd share and save anyone else the same hassle.
Affected software:
Windows 7 64bit (perhaps Vista and perhaps 32bit versions too)
Lightroom 2.6
The Problem:
Lightroom refuses to launch except when using the "Run as Administrator" option.
The cause:
I had changed the Library setting for Windows Media Centre to exclude the "My Pictures" folder as thousands of images were slowing it down.
Lightroom by default keeps it's catalogue in "My Pictures".
The solution:
Restore the library settings to include "My Pictures".
--
It seems that Windows 7 and perhaps Vista too (as they are the same
) changes the folder permissions when you exclude a folder from the Media Centre Library which meant that Lightroom couldn't read its own catalogue without Admin rights.
I've submitted this as a bug to both Adobe and MS (who's fault it is).

