MS Accounting 2007

Have a client with the software installed on (1) PC only. This is in single user mode. It has been used for several months now with no problems. There are (2) company files which are maintained. When they tried to open one of them, this error message popped up:

"The company could not be opened. Please ensure the SQL sever exists, the service is running, and that the access has been granted." I have looked at all the instants on google I could find, but most were related to multiuser problems. Any suggestions?

Tried these?

Thanks NooNoo, will double check this info later today and get back to you.

NooNoo, have not made it out to the client's yet. It's a family owned business and they decided to have some vacation time. Will try it when they get back and post the results.

Whenever you are ready.

Was able to catch their office open and tried all the methods suggested. None of them worked. Figured possibly the datsbase maybe corrupted as well since I am able to open the other company file they have with no problems. I suggested for them to get Quickbooks for their database, client information and inventory tracking.

Zonie, just like Quickbooks, MS Office Accounting includes tools to repair database errors. They are under the Files, Utilities, Data Utilities menu.

When it comes to Quickbooks, I sorta feel like one of those guys who rants about how he'll never use Word or Excel because of how evil Microsoft is. But that's exactly how I feel about Quickbooks. Except that Intuit has worse support than MS, and really locks you into mandatory periodic upgrades if you use any of their business services such as payroll or credit card processing.

If the company data is so corrupted that it can't be read by MS Office Accounting, migrating them to Quickbooks isn't going to change that; they will still have to do a lot of manual data entry to rebuild the file. Moving them to Quickbooks would just add the cost of the software to the investment in time.

Quote:

---

Originally Posted by slgrieb

Zonie, just like Quickbooks, MS Office Accounting includes tools to repair database errors. They are under the Files, Utilities, Data Utilities menu.

When it comes to Quickbooks, I sorta feel like one of those guys who rants about how he'll never use Word or Excel because of how evil Microsoft is. But that's exactly how I feel about Quickbooks. Except that Intuit has worse support than MS, and really locks you into mandatory periodic upgrades if you use any of their business services such as payroll or credit card processing.

If the company data is so corrupted that it can't be read by MS Office Accounting, migrating them to Quickbooks isn't going to change that; they will still have to do a lot of manual data entry to rebuild the file. Moving them to Quickbooks would just add the cost of the software to the investment in time.

---

I agree and side with you, however this person has messed this account up twice before. Their wattage is about 15 watts, but they do know how to use quickbooks hence the suggestion to use this instead.

hmmm which is cheaper, training the screwup or getting locked into quickbooks which in turn locks you into a particular OS and way of doing things?

I take it there is no backup of critical data???:knife:

Quote:

---

Originally Posted by NooNoo

hmmm which is cheaper, training the screwup or getting locked into quickbooks which in turn locks you into a particular OS and way of doing things?

---

Realistic, cheaper in this case to go with the Quickbooks for this person. Her part of the business is just for the inventory of wrinkle reducing creams, sun protection, and invoiceing for the products. No online access to the bank or anything critical.

Quote:

---

Originally Posted by CeeBee

I take it there is no backup of critical data???:knife:

---

Despite the warnings I gave about backups, Quote(" I just haven't had the time yet") hence no backup.

Quote:

---

Originally Posted by Zonie

Despite the warnings I gave about backups, Quote(" I just haven't had the time yet") hence no backup.

---

Automated daily backup on an external drive or tape??? I mean come on...

Hey, I am just the messenger, you can lead a horse to water.........., if they don't want to purchase an external backup drive, sooner or later the message will get across.

NO, what will happen Zonie is that YOU will be blamed. You didn't warn them properly, you didn't make them do it so they are not going to use you again and tell all their friends what a useless tech you are... Unfair? Absolutely.

Write them a document of a backup recommendation which states what they might lose if their hardware goes down and have them sign it. Then if they do blame you, you can remind them of the paper they signed when you sue them for damages :D

Well, I guess I tend to side with Zonie here. The more clueless (EUPHEMISM) folks are, the more they resent being made to feel clueless, and the more likely they are to take offense. I'd guess Zonie is less likely to be sued than to lose a customer for pushing the backup issue too hard.

If someone really wants to sue, they'll do it no matter what kind of release they've signed off on. The results in court are always unpredictable whether you're in the right or not.

Update!!!! While working on th PC just recently, the omputersname had been changed. When the correct name of the computer was reinstated, the problem with MS Accounting went away. Seems the program uses the name in the system for referrence. Problem resolved.