Batch delete of accounts

  • Thread starter Thread starter PhilAllen
  • Start date Start date
P

PhilAllen

Hello,

We have nearly 4000 accounts in our database and now find that when we try
to link an email to an account the list of names takes 15-20 seconds to load
which is starting to get quite frustrating as it is a regular action for us.

Is there a way of excluding accounts from this list (many of the 4000 are
now redundant) or possibly removing them from the system altogether (after
backup)?

I would manually delete them but I'm not sure that all associated histories
and links would also be deleted, our DB is 1.5GB in size and could do with
quite a bit of housekeeping.

Many thanks

Phil
 
Hello,

We have nearly 4000 accounts in our database and now find that when we try
to link an email to an account the list of names takes 15-20 seconds to load
which is starting to get quite frustrating as it is a regular action for us.

Is there a way of excluding accounts from this list (many of the 4000 are
now redundant) or possibly removing them from the system altogether (after
backup)?

I would manually delete them but I'm not sure that all associated histories
and links would also be deleted, our DB is 1.5GB in size and could do with
quite a bit of housekeeping.

Many thanks

Phil
Click to expand...

Deleting a BCM entity deletes all its children, in general. However,
be aware that you need to delete items twice, the first delete only
marks them as deleted (they show up in the Deleted Items folder).
Deleting them from the Deleted Items folder actually removes them from
the database.
 
Many thanks Luther.

We are looking to switch over to the Accounting package so in hindsight
deleting records may not be the most sensible idea. On reflection, is it
possible to exclude records from the 'Link to Record' list? I was hopeful
that the 'Active' flag would achieve this but it appears that is not the
case. I've even tried to find the SQL Stored procedure for this to have a
play around but haven't found it yet.

thanks again

Phil
 
Back
Top