Many duplicates Names in Accounts

I have some 50.000 Accounts and there are some 7000 with duplicate Names
I tried the standard “Duplicate Query” and there I see some name 4 or 5 times double name.
I tried to delete, but get always ““you have to close the open database and then delete,”” BUT THAT IS
my problem I don’t know to get it done. (close and then delete)

Is there an other way? more simple?
William
I have SuiteCRM local version 7.6

Hey there,

Have you found a solution for this, by chance?


I’m not 100% sure what you mean by “you have to close the open database and then delete”
Is this an error that appears on-screen?

Do you have a screenshot of this, by chance?


Also, which Duplicate Query are you referring to?
The “Find Duplicate” action in the CRM, or something unrelated?


If you have Database access you could potentially clear up Duplicate Records with SQL Queries
(Though make sure to back-up the data beforehand, as this will be a hard-delete of data)