08-21-2013 08:07 AM
We recently found that 2 of our contacts had disappeared from our ACT! Preium 2012 database. I noticed that we have crossed over 10,000 contacts - does anyone know of an issue with database size and contacts disappearing? We are looking at scrubbing our databased to make it smaller, but any help is appreciated. Thank you.
08-21-2013 08:39 AM - edited 08-21-2013 08:41 AM
Hi Keith and welcome to the community forum.
First, I am not an engineer, but as a frequent user of the forum, I've seen this question asked before. You might want to search on size limit.
What I've seen before is that you are only restricted by the size of your HDD. Other will chime in and give you more informatin.
I did a search, and this link on the forum may help:
08-21-2013 09:07 AM
Firstly size is not a problem and you would get error messages, I have over 250,00 in one client database. I do get this question regarding missing records several times a year and in nearly all cases it has either been inadvertently deleted or is in the database with another spelling etc.
First search on the postcode to see if it brings up the record/s. If not do a Keyword search on the company name. ACT normally records the names of deleted records in the history of the user who deleted them so Keyword search will also find the culprit if this has happened.
Lastly you can re-index the database under tools, Database Maintenance in case the indexes have become a problem, this can happen if there has been a data import. In exceptional circumstances it is possible for the SQL table to corrupt and need rebuilding in a tool called ACTDIAG but I doubt this is the problem.
08-21-2013 09:11 AM - edited 08-21-2013 09:12 AM
@ jnpurdy --- Thank you for the link. Based on the discussion there and the size of the servers and disk space in our organization, it is probably not a size problem. Thank you
08-21-2013 09:43 AM
Typically someone will have inadvertantly edited the contact name and a search by contact won't find them. Try some diferent searches and see if you are able to locate their record. Also try a contains search for part of their name in the contact field.
08-21-2013 09:49 AM
When the contact was deleted all associated data was also deleted. If you have a recent backup you can do a restore as of the backup with a different name and then export the missing contact from the backup to the working database and include all the notes and history.
Be sure to make a safety backup of your working database before attempting such an operation.