Community
Showing results for 
Search instead for 
Do you mean 
Reply

All Contacts have Disappeared

New Member
Posts: 9
Country: USA

All Contacts have Disappeared

[ Edited ]

Community,

 

All the Contacts in one database were gone; save 1, mine, the User account.  -- however --

All the Companies were  visibile, though no contancts were associated with any of the contacts.

 

There are 535 contacts and 160 companies.

 

I ran ACTDiag.exe and rebuilt / reindexed the database

had a message that there were a lot of errors.

 

Still the *.ADF size is 36,000 KB

and the *.ALF size is 10,000 KB

 

Any thoughs / services to restore.

 

John,

In Annapolis, MD

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: All Contacts have Disappeared

Did you by chance delete a contact? If ao sis you delete the single contact or the lookup?

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 9
Country: USA

Re: All Contacts have Disappeared

I don't know if I deleted any contacts for the file became corrupted.

 

When I looked up all contacts, only my record was visible.

Still the files are very large.

Yet 1 record and 160 companies are visible.

 

Thanks,

 

John,
In Annapolis, MD

 

 

Nickel Elite Contributor
Posts: 934
Country: USA

Re: All Contacts have Disappeared

What complete version of act are you using? refer ACT! / Help / About

What was the error message?

Do you have a backup of your database?

FSBill

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
New Member
Posts: 9
Country: USA

Re: All Contacts have Disappeared

My Version:

Sage ACT! Pro 2011 Version 13.0.401.0, Hot Fix 2

Operating system:

Windows 8.1

 

I have added a lot of records since my last backup.

I know the data's "in-there" due to the size fo the files.

 

Any suggestions to "see it"

 

John

In Annapolis

Nickel Elite Contributor
Posts: 934
Country: USA

Re: All Contacts have Disappeared

[ Edited ]

John,

Now What was the error message?

That needs to be addressed first.

 

Then

You should be on svcpak1 hotfix6

reference 

http://act.com/support/downloads/sage-act-pro-2011/


Size   34100 KB    12/16/2011
ACT2011SP1HF6.exe  Sage ACT! 2011 SP1   Hot Fix 6

 Note:

It appears you maybe have not installed service pak1 even although you do have hotfix2?

You may need to do service pak1  first, then get the svcpak1 hotfix6 item..

Manually download and install it - close act prior.

But lets get to the error message first.

 

FSBill

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
New Member
Posts: 9
Country: USA

Re: All Contacts have Disappeared

Bill,

 

My version is now: Sage ACT! Pro 2011 Version 13.0.401.0, Hot Fix 2

 

I've detached, repaired and re-indexed the db multiple times

 

Still,

Only 1 contact (mine) and the 160 companies are visible, no contacts, no notes.

 

The .ADF file is: 35,008 KB

The .ALF file is: 25,088 KB

 

So the data is 'in-There'.

 

Any thoughts? / Any one?

 

John,

In Annapolis

Nickel Elite Contributor
Posts: 934
Country: USA

Re: All Contacts have Disappeared

[ Edited ]

John,

 

In your initial post you stated that you encountered error messages;

I ran ACTDiag.exe and rebuilt / reindexed the database

had a message that there were a lot of errors.

 

If you can tell me what the error was, I can tell you how to resolve.

You can lookup the error msg in the act knowledgebase.

What happens if you perform a File Save Copy As and create a copy of your data base?

 

Try this resolve

http://kb.swiftpage.com/app/answers/detail/a_id/19640/kw/actdiag%20message%20several%20errors

FSBill  Smiley Happy

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: All Contacts have Disappeared

Under the circumstances, the database file size has little meaning, The most likely cause of the missing contacts is that you inadvertently deleted all the contacts except your my record which can't be deleted. Because companies are in a separate table from the contacts, deleting the contacts wouldn't delete the company records. There is a remote possibility that the database is internally corrupted and that's what's masking the contact records. If I had the database on ly system I'd check the actual contact table with SSMS however I think I would find only one contact record.

 

At this point I would suggest that you do a Restore As of your database backup using a different database name so that it doesn't overwrite your present database and do as much manual recovery as possible.

 

Sorry for the bad news.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Nickel Elite Contributor
Posts: 934
Country: USA

Re: All Contacts have Disappeared

[ Edited ]

John,

 

My prev reply should show you the way to zannadoo?

That kb article prob holds the key to your resolve. there should be a sql fix shown in that article?

You could try deleting your Preferences using actdiag? minor inconvenience reseting your preferences.

 

But,

I have actually seen ACT!2011 Pro do this on my pc and others.

Also there was no info in that my record contact,

Here is how we resolved it.

 

In the contacts module where you only show 1 contact,

select a different Contact Layout

close act!

re-open act!

 

But since you mentioned that you ran actdiag and had some sort of msg stating that you had many errors, that is why I did not offer that solution earlier. So try it and see what happens.  Smiley Happy

 

Take daily backups moving forward. Using ACT! / File / Backup database

also backup your personal file items daily.

 

FSBill

 

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html