I have tried everything to rid myself of this error, and I cannot. I
am trying to create tables from my application as it needs them. What
I am experiencing is that after a table has been used in a query,
creating foreign keys, or dropping foreign keys to that table is
unreliable at best. For your knowledge, I am using the C API. I have
taken many suggestions on how to fix it. I currently am using a
single connection, and when trying to alter the keys I only allow a
single statement to be created, meaning all other statements have
been deleted. I have even gone so far as to disconnect and reconnect
my connection before trying to alter the keys. I still receive the
object in use errors, are there any other suggestions?