Good common sense advice.
I shall probably be stoned to death as a criminal heretic, but I do have quite a few Access 97 applications which use SQL Server through attached tables (why is everyone reaching down to pick up a rock?).
The problem there is that in the attached tables "remember" my connection string (ODBC, of course).
I suppose I could write a routine that reconnects the tables on startup changing the attributes for the workstation name.
Anyway, for all ADO based applications and for ODBC connections made through code, I think this article contains very sound and simple good advice.