When tryging to add FKs I often get "Table is in use" for the referenced
table, even though no remaining programs are open that use this DB. Are
these left over transactions that were abandoned?

I thought so - but in this last case the table (Country) it said was in use,
is NEVER written to. Its static data that is only read from.