Can't delete record on main form, The table is already opened...error

[5bhaya]

I need help to solve this problem.

I have two tables, Main table (tblProdDataLog) and linked table (tblProdDetails) with one to many relationship.

I have a main form called frmProdLog and the subform on it called subfrmProdDetails. The both forms are linked on child-master field "DataLogNo". The subform gets its data from qryBottleDetails.

The Main form has production date in addition to other fields and the subform's fields are related to the production data for this field.

My main problem is that even if there is no data on the subform, one I enter any information on the main form, I can't delete it through the Delete button on the main form or from the delete button on the menu bar. It gives me an error "The table 'tblProdDetails' is already opened exclusively by another user, or it is open through the user interface and cannot be manipulated programmticaly."

Any help is appreciated.

Thanks in advance.

PS: I have no problem deleting the data from the table tblProdDataLog.

 

[willir]

5bhaya

Long shot...
Check your record locks...
From the menu, "Tools" -> "Options" -> "Advanced" tab

You may have "All records" selected.

I open a database as...
Default open mode: Shared
Default record locking: Edited record
Open databases using record-level locking enabled.

 

[5bhaya]

I have done what you suggested, still the record will not be deleted!!!. It gives the same message.

Thanks in advance for your help.

 

[5bhaya]

Finally fixed with the help at another forum. My subform's record lock was on "all records", once it was removed, it worked fine.