Access/Oracle : series of records stay locked.
Posted on 2000-05-09
We use oracle 7.3.4 and access 97 and odbc driver oracle73 ver 2.5 2.05.03.01 sq032_73.dll 11/3/98
My problem is that a lot of records in access stay locked even when all the users have closed ms-access and i did a shutdown & restart of the oracle database.
Now i make a copy of the table in access, then delete all the records with SQL Plus in oracle and then append the copy to the origional table.
But more and more i have to do this, who knows a good solution.