I've written many queries in the Access QBE that reference linked tables.
Often, when I reopen a query many of the fieldnames are suddenly replaced with Expr1: OldName, Expr2: OldName2 etc.

Any idea why this is happening?
How to prevent it or how to fix it?

I assume it's got something to do with the remote (SQLserver) table structure changing, e.g. new fields added, but I religiously do the "update linked tables" thing.

Thanks, DaveBo