S
Steve Jensen
I have an Access 2000 database with an ODBC attachment to
several SQL 2000 tables. In trying to append records to
two consecutive tables that contain Identity columns, I
have encountered a problem:
Identity_Insert On can only be called once in a session,
so the first append succeeds and the second fails (the
append overrides the identity column in both cases).
What SQL syntax can be actually included in an Access
query to reset the Identity_Insert? Or is there some
other way short of writing and calling a stored procedure?
several SQL 2000 tables. In trying to append records to
two consecutive tables that contain Identity columns, I
have encountered a problem:
Identity_Insert On can only be called once in a session,
so the first append succeeds and the second fails (the
append overrides the identity column in both cases).
What SQL syntax can be actually included in an Access
query to reset the Identity_Insert? Or is there some
other way short of writing and calling a stored procedure?