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
"Luther" wrote:
[Quoted Text] > On Nov 29, 6:13 am, PhilAllen <PhilAl...[ at ]discussions.microsoft.com>
> wrote:
> > 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
>
> 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.
>
|