Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Contributor
George Wilcox
Posts: 15
Country: United States
Message 1 of 5 (1,824 Views)

Records Deleted in ACT! 2010 Hotfix 2 still exist in underlying tables!

[ Edited ]
Hi;

I have a client who has deleted some 27K blank records in ACT! 2010 Premium for Web that were created when he imported Excel spreadsheet data that had lots of empty rows at the bottom of the sheet that ACT! apparently didn't handle.  When we do a lookup in ACT! the records that were deleted don't show.  However, when we look at the database with SQL Server Management Studio Express using the sa password and query the contact table, we see that the records still exist in the underlying tables.  How do we get it to actually delete them to get the best performance from the database?
Message Edited by George Wilcox on 11-15-2009 07:11 PM
Please use plain text.
Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,627
Country: United States
Message 2 of 5 (1,786 Views)

Re: Records Deleted in ACT! 2010 Hotfix 2 still exist in underlying tables!

Try doing database maintenance.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders
royel@techbenders.com
Please use plain text.
Copper Contributor
George Wilcox
Posts: 15
Country: United States
Message 3 of 5 (1,777 Views)

Re: Records Deleted in ACT! 2010 Hotfix 2 still exist in underlying tables!

Hi Roy;


I did try that before posting - no luck there.

Please use plain text.
Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,627
Country: United States
Message 4 of 5 (1,771 Views)

Re: Records Deleted in ACT! 2010 Hotfix 2 still exist in underlying tables!

Including the maintenance and repairs available in ACTDIAG?
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders
royel@techbenders.com
Please use plain text.
Copper Contributor
George Wilcox
Posts: 15
Country: United States
Message 5 of 5 (1,734 Views)

Re: Records Deleted in ACT! 2010 Hotfix 2 still exist in underlying tables!

Yes, I tried it all - I even tried doing a backup and restore, thinking that if ACT! wasn't displaying these phutntoms, perhaps it wouldn't backup and restore them, but no such luck. 
Please use plain text.