ThE error IS:
Deletion failed.
Details: The DELETE statement conflicted with the REFERENCE constraint "XX_XXXXXXXXX_XX". The conflict occurred in database "XXXXXXXXXX", table "xxx.XXXXXXXXX", column 'XXXXXXXXXXX'.
The statement has been terminated.
Access RDB runs on a relational database which means a lot of the information it stores is linked to other records. If a record has links the system will not allow you to delete them until you remove all links.
In order to know which links you need to delete you will need to look at the table and column which appears in the error. If you need more guidance on what specifically is causing this error, please contact us via the MyAccess portal and reference the title of this article, what you are trying to delete and the full error code you are receiving.
Our support team will be able to provide guidance but will not be able to remove the links for you. If there are links that can't be removed or if there are multiple links please speak to your Customer Success Manager or Account Manager to arrange for our Professional Services team to quote you for a data cleanse.
