|Well, an update on the situation. I have Sun Java back on my home computer again. But it was actually more related to what BLAQ OUT's suggestion.|
I went ahead and created another User with Computer Admin rights. Logged in and immediately tried Java installation, same thing. Then I downloaded the Offline installation from that profile and ran, same thing with my default account, the executable just pops up and disappeared. So I then right clicked on executable and chose Run As Administrator. Next thing I know, Sun Java's executable popped up and Java 6 RT 11 is on my computer.
So since this worked, I started wondering, I am not using a server at home (default Workgroup setting) and under User settings in Control Panel and Local Policy, my profile was in the Administrator group. Have my account and the newly created test account suddenly became a "Power User" (Under Domain setting) by a Group Policy that supercedes the Local Policy where only the computer's Administrator can install software? My suspicion was further noted when my Logitech Mouseware application in the Taskbar constantly said there is a new update for the software even after the download is supposedly installed. Downloading the software/driver from the Logitech site and running that under my default account showed that it cannot complete the process, where if I ran it "As Administrator" then it will install. Further more, I ran Scandisk, and I can't even get to Phase 3 before it told me that it cannot complete the operation.
Having said that, I seem to recall a couple of weeks back having came across some XP Update on Microsoft Update, and after confirming with a friend using Vista where whenever he had to install a program, he had to Run as Administrator, I went to look around my update history on Microsoft Update, and the only thing that looks familiar is this: Group Policy Preference Client Side Extensions for Windows XP (KB943729) installed a couple of weeks back (I think it was listed as Optional).
After uninstalling it, I was able to run Scandisk with my own account. Have not tried to see if I am able to install any applications yet though. If this was really the cause, I will be darned. Perhaps my default profile wasn't really corrupted and I didn't need to remove Java in the first place, it was just that I didn't have sufficient rights to install. But having said that, if every time I needed to update a software, run a maintenance function (like Scandisk), uninstall a program, I needed to involve my Admin account, to me it is kind of a hassle. But I suppose that is why it was listed as optional.
According to the friend who uses Vista, that's what it is like in Vista. I understand it's a security measure, but that just kind of took me by surprise. So long story short, I got Java back on my PC, and in the process, stumbled onto something else.