Example: I have a database with 100 fields, all of them are mandatory (to avoid blank cells). Suppose I create a new record, and after entering 10 fields I realize that I need to delete this record. Now, access does not allow me to do anything till I enter all the 100 fields and complete the record.
Is there a way to allow deletion of such half-complete records with mandatory fields?