jet + odbc sql 2005 expr- cannot delete record - complex question

D

diegoff

Hi,

I'm creating a front end ms access form to manage a sql 2005 express
database via odbc.

I'm using a main table called dbo_tab_interv. As far I create records
manually ( fast input directly into the table ) there are no problems and I
can delete records aswell, but if I create a record with the followiond
query:

query1:
INSERT INTO dbo_tab_interv ( interv_data, interv_client )
VALUES (now,'acme s.r.l.');

I cannot delete it no more from the table unless I use another query such
the following:

query2:
DELETE FROM dbo_tab_interv
WHERE interv_id = 48


If I try to delete records created via "query1" manually the error is the
following:

" The Microsoft Jet database engine stopped the process because you and
another user are attmpting to change the same data at the same time"

Nobody exept me is working on this db

Thanks in advance

Diego
Diego
 
Top