Mr Richard

Thank you,

Yes, to be away the problem ... But, I need also to change the auto number and the only way is to insert data with the new value...

Thank you

Yes, I need to have the autonumbers on the second and third tables. It must be a key in each table. For the application, management and accounting, from time...

Thank you.

Yes, I am inserting data into the primary keys, and SQL Server allows insert data into the auto number field the first time we open (execute) Query_1. The second...

Thank you

Yes, absolutely we need to have

SET IDENTITY_INSERT Table_B ON

Run query_1

SET IDENTITY_INSERT Table_B OFF

SET IDENTITY_INSERT Table_C ON

Run query_2

SET IDENTITY_INSERT Table_C OFF

But, Run query_1 is in .mdb access database,

exactly...

The result of Profile during running Query_1 and Query_2 :

Line 1 017/09/2003 17:05:00

Line 2 14 -- network protocol: LPC

set quoted_identifier on

set implicit_transactions off

set cursor_close_on_commit off

set ansi_warnings on

set...

The problem exists and it is very easy to reproduce

IF and especially IF :

i)the tables have a field counter sequentiel 1 by 1 (automatic number)

...

Hello Allen Cui

Thanks

The result of sp_who2 :

1 BACKGROUND sa . . LAZY WRITER 0009/16 21:32:0 ...