The inability to delete a record can be caused by various situations. While Cascade Updates and Cascade Deletes might be a setting you're missing and that is preventing this, I strongly advise stepping back and re-evaluating this practice. Not only can you end up with orphan records (those that no longer have a "parent" related record), reinstatement of a condition (e.g. user returns) means you need to recreate that which you have deleted, and for no good reason. It is unlikely you are about to run out of space unless maybe you're putting attachments in Access tables (and that is a different problem) but you are losing historical data. Where users are concerned, you are better off changing their status, and that is best done via a date field (e.g. InactiveDate). You simply ignore those whose Inactive date is not Null.
Last edited by Micron; 06-20-2019 at 04:16 PM.
Reason: correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.