10-01-2008 09:07 PM
10-06-2008 03:05 PM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
10-06-2008 05:56 PM
I have started an archive DB, exported about 1500 of my old contacts to the archive DB and then deleted them from my primary DB, leaving about 1500 contacts in the primary DB. I then purged data over 5 years old using the "DB Maintenance", "Purge Old Data" Tool. I then went into the Attachments folder and deleted attachments older than 5 years, and then started to manually open & delete attachments that were no longer needed.
I remember reading in an ACT Knowledge Base article that when you perform DB maintenance (Integrity and Re-index), that ACT is supposed to delete attachments that do no have an associated contact in the DB. I have performed the DB Maint/Check and Repair many times since deleting half of my contacts from my primary DB, however, the number of attachments in my Attachments folder did not change. In fact, as I started manually opening & deleting attachments from the Attachments folder, I noticed that many of them were from contacts which are no longer in my DB. So, is there a way to delete attachments from the Attachments folder which no longer have an associated contact in the database, other than by opening up the attachment, confirming it belongs to a contact which is no longer in the DB, and then manually deleting it? Thanks.
01-12-2012 08:55 AM
I know this is an old post but while looking for a solution I found one, so I figured it be worth adding to this post.
The issue when you just manually delete a file in the Database\Attachments> folder there is still a reference pointing to it in Contact record Documents Tab.
I have and ran Exponenciel http://www.exponenciel.com/ program "Purge Notes & History" which has a check box to select to also remove the Link to a file. After that is done you can go into attachments folder and delete the files.
03-16-2016 02:57 PM
I know this post is old, so someone may not even reply, but I thought about the manual deletion of Attachments on the main db server. Does that mean that we have to do the same thing for remote databases at the same time? We are worried about synching. We have Act! 17.2
So far, I have found nothing to confirm the action.
03-16-2016 03:58 PM
03-16-2016 10:00 PM - edited 03-17-2016 09:22 AM
I could not find a way to remove mass number of files attachmented to contact records that would also remove the link in the contact record documents tab.
Contact these companies to see what they can do.
Maybe he can create a custom add-on if convert attachments to shortcuts does not work for you.
ps I just edited this post to correct typo's
03-17-2016 09:01 AM
I just found that. We are going to test a small sample and see what occurs.
I'm definitely not an Act! novice just yet. ;-)
Thanks for the feedback. Have you used it successfully, Gary?