Error 3197 -Help!

[gc]

I have an access 97 database as the front-end and data are stored in SQL server. There is a form which is based on a temp table. This temp table is based on two linked tables from SQL server. I use DAO to create the temp table, then display on form. After user cahnges data on the form, I use another DAO to move data back to two original tables in SQL server. It worked fine. But recently when run the second DAO I got an error message: "Error #3197 The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Source: DAO recordset)"
I know that I am the only user.
Then I found I can't delete any records in both linked tables from Access but I can change data in the fields. I can't figure out the reason. Where is the problem? In SQL server or Access?
Please help and any idea is great appriciated!
george

 

[cmmrfrds]

I use ADO, so I am not completely fimilar with the DAO syntax. From what you described, it sounds like there are 2 update cursors open to the table(temp) at the same time. Try closing the first recordset connection before doing the second DAO call.