Martijn, Daniel, all,

>>> - You play safe and detach. If there's no other attachment, this action
>>> ensures the engine itself unloads the db from memory and frees the file
>>> handles associated with it. Next time you connect, your metadata change
>>> should succeed immediately."

>> Disagreed -- when creating a FK, you will get the "object in use"
>> as well, if there are more than 1 connections to the db. Even without
>> a SELECT on the tables involved.

D> I agree with you. One of my findings(that I just remembered) was that
D> I got the error "object in use" when creating a second FK on a second
D> table.

I believe this is the slightly special case which manifests itself as
"object INDEX is in use". It looks like INDEX is a sort of catch-all
pseudo-object that prevents you to add two keys one after another.
"object WHATEVERELSE is in use" is the more general case that is
explained in this thread.

Ciao
--
Nando Dessena
mailto:nandod@...