At 03:47 PM 13/12/2004 -0500, you wrote:

>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?

You must have an exclusive connection to a database to add or change
foreign keys. Additionally, if you're using a tool that has the table open
(even if you are the only one connected) then it's in use.

>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.

It doesn't have to be written to, to be in use. If it's open, it's in a
transaction and, if it's in a transaction, it's in use.

./heLen