SQL Server rows not editable for Access after Insert

Question

I have this problem: I'm using a SQL Server 2008R2 backend and MS Access 2000 frontend where some tables are connected via ODBC.

Following Structure (Tables all on SQL-Server):

• Import (not connected to Access)
• Products (connected via ODBC to Access)
• Pricing (connected via ODBC to Access)

I want to fill the Pricing table automatically with some data from Products and Import. This is supposed to run as a SQL Agent job with a T-SQL script. I want to insert the data from "Products" with following command:

INSERT INTO Pricing (Productnr, Manufacturernr)
    (SELECT Productnr, Manufacturernr 
     FROM Products 
     WHERE Valid = 1 
       AND Productnr NOT IN (SELECT Productnr FROM Pricing ));

Right after that the inserted rows are locked for Access, I can't change anything. If I execute sql queries with SQL Server Management Suite or if i start queries as SQL Agent jobs everything works fine.

Why are the rows locked in ms access after the query ran (even if it finished successfully)? and how can I unlock them or make it unlock itself right after the query/job ran?

Thanks

Answer 1

Got the solution for my Problem now.

I had to add a timestamp row into the pricing table, so access could recognize the change.