Jet stopping updates

[suzreid]

Help!!

I have a single user Access front-end, Oracle back-end application. The Oracle info is dumped into temporary Access tables. My problem is that I get the following error
'The Microsoft Jet database engine stopped the process because you and another user are trying to change the same data at the same time'

I have written Access and Oracle procedures and functions that
1. deletes the record from the Access table (using a recordset that is set to nothing at the end of this sub)
2. deletes the record from the Oracle database. This uses an ODBC connection to link to an Oracle procedure that deletes the record from the Oracle table. After the Oracle procedure has run the ODBC connection terminate.
3. The data is refreshed and then the error appears.

I am the only user changing any of the data and can't see where the 'other user' is coming from.

This method is used for deleting other records from the application without any problems. I seem to be banging my head against a brick wall at the moments.

Can anyone help?
Suz

 

[RickSpr]

I don't have ODBC experience, but I notice you say you set the Access recordset to Nothing--but you didn't say you closed it. An explicit close might help.

Also, maybe you need an explicit Commit, especially if you're not using transactions. On mainframe distributed DB2 databases, even when you close a connection, it persists until a Commit is (implicitly) done, so that synchronization can be maintained.