Windows 7 Mate aWNDA3100V2 with Linksys WRT54GL

All clear now - the two networks, the wireless and the wired lan are using the same subnet addressing - 192.168.1.* That means they are conflicting you cannot have two networks on the same subnet as obviously your pc doesn't know to which one you are referring. You need to change one of them to use them concurrently and as the hotspot is presumably beyond your control the only solution is to change the addressing structure on your router. That will involve changing the address of the router itself - if your using dhcp all other changes will be made by the router in allocation addresses. You could make the router 192.168.0.1 for instance.