Confusing IDENTITY_INSERT error, says it is already on in another table : <p>I'm trying to rebuild a database from a text file, using VBA. To insert the ID values, I call this before sending in the INSERTs:</p>

<pre><code>SET IDENTITY_INSERT TableName ON
</code></pre>

<p>This seems to work fine for most TableNames, but when I call it on table 'Accounts' I get an interesting error:</p>

<pre><code>"IDENTITY_INSERT is already ON for table 'test.dbo.PropertyAssets'. Cannot perform SET operation for table 'Accounts'."
</code></pre>

<p>I'm guessing this has to do with fkey constraints or such, but does anyone know for sure?</p>
