Depends is I think the answer. I have a Qantas account from the 1990s which lay dormant for many years. When I started flying locally within Aus again, I added it to my booking and all was as smooth as if I had never been away.
Many years, I think, more than 5 at least...