Same issue here: WinXP64Pro, Celeron 64 bit processor (yes, there are such things as 64 bit celerons, search for them before you post), 1 Gig system ram, some system ram is shared to on-board graphics, Avast Home edition installed (registered), worked fine in the beginning, now freezing.
I have some additional information to assist troubleshooters.
1] My PC is never left on all the time, it is powered off until I wish to use it.
When I wish to use the PC, I apply power to the PC, it goes through bootup process (normal for me is GRUB (because I dual boot with Linux), where I manually select Windows XP), booting to the Windows XP welcome screen.
2] From this point, I have 10-20% chance of logging in as my default user without ANY problems.
Important note: the other of the logins all fail no matter which user I elect to log in as.
It was suggested in another forum (TechIMO) that I should try a guest login (possibly they thought my normal user was the problem?). I have had no replies to that thread, after I posted that freezing does not matter which user I select.
3] Actually, the freezing occurs within 5 to 15 seconds of the login screen appearing, so sometimes I can click my icon AND type in my password and then I freeze, sometimes I can’t even click my user icon and the system is frozen.
That timing makes me think the failure is NOT a user configuration file (many freezes take place before a user has logged in). To that end, troubleshooting should consider what XP system files are loaded (by windows) before anyone even logs in.
4] I am using SP1 only, it was included with my XP64 CD; no updates are permitted on this machine.
Why? I have heard horror stories about 32 bit XP getting REALLY trashed by service packs, so why would I want to take an even greater risk on updating the LESS popular 64 bit XP?
More:
Presently, I am using a selective startup to disable automatic starting of Avast until I can determine if Avast is the root cause. So far, I have succeeded in logging in once while Avast is not started. But this could also be part of my usual 10 - 20%.
I use DSL.
I use a wireless connection to my wireless router, that connection recently got misconfigured, but is working fine for the past 2 days; today, I had to reboot 6 times, due to freezing at login (I finally chose safe mode and activated the selective startup that I just mentioned). Back when the network was malfunctioning, I was not refused ANY logins, so I’d say the network being functional MIGHT be part of the problem (again, the 10 - 20% success thing might have let me in when the network was malfunctioning).