08-31-2010 12:28 PM
08-31-2010 01:56 PM
Thanks Mike. It appears we are having SQL issues. See below - any ideas?
Good morning -
We are using ACT! 2008 Premium for Workgroups Version 10.03.182, Hotfix .
When attempting to remove inactive/active users from a database we receive an error message after we receive the prompt to remove the contact from the database - when choosing either option (Yes or No) we receive the following:
The INSERT statement conflicted with the FOREIGN KEY constraint "USER_COLUMNACCESS_USERID_Fk". The conflict occurred in database "GoLead", table "dbo.TBL_USER", column 'USERID'. The statement has been terminated.
We have also had many problems regarding speed. Our database has over 117,000 records in it and we were told that eliminating inactive users may help this problem. Any help would be greatly appreciated! I searched the knowledge base and couldn't find anything.
08-31-2010 02:11 PM
This sounds like a database corruption as per this ACT! Knowledge Base article -
Don't use the link there for Export/Import ... it's for the wrong ACT! version.
Then try repair with ALL options as per:
If that doesn't help, I'd contact database services to see if they can repair it