Problem on Insert betwween Tables linked to SQL Server

Z

Zouhir ABID

In access 2002 database .mdb ,
3 tables Tab_A, Tab_B and Tab_C linked to SQL Server 2000
The 3 tables have the same structure
with primary key auto number counter 1 by 1
The table Tab_A has data
The others Tab_B and Tab_C are empty (no data)
Query_1 to insert all data (*) from Tab_A to Tab_B
Query_2 to insert all data (*) from Tab_A to Tab_C
run Query_1 : succeed (no problem)
run Query_2 : failed (not completed) and any query insert
data is totally locked

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Problem 0
SQL Problem 2
Editing tables linked from Access to SQL-Server 4
Linked tables to SQL and how to handle triggers on SQL ??? 4
linking to SQL Server db table 6
Append tables from mdb to SQL Server 2005 3
dbSeeChanges problem in Access with linked SQL Server table 4
ODBC – insert on a linked table ’table_machine’ failed 3

Top