06-24-2010 02:19 PM
We use ACT! 2009 v. 18.104.22.168, Hotfix 1, for our small business. The Master Database is on my desktop and the Remote is on my boss's laptop. We use ACT every day but 2 or 3 days a week when she tries to open ACT she gets this error message "Database could not be accessed, Check your network connection...". To fix this we simply restart her computer and everything is back to normal.
I've seen several threads with the same error message but not necessarily the same scenario or solutions. We are able to access the remote after the reboot but most of the time it isn't a convenient thing to do. Any suggestions as to how to keep this from happening?
06-25-2010 05:48 AM
Hello Learning Links,
Welcome to the Act! Online Community!
Since the reboot of the computer corrects the issue, it sounds like the SQL service is being stopped which blocks your access to the database. The next time it happens, try this:
- click on Windows Start button
- select Run (XP) or use the Search field (Vista/Win7)
- enter the command 'Services.msc'
- scroll down to locate 'SQL Server (Act7)'
- look at the Status column - if it is blank, the service is stopped
- right click on 'SQL Server (Act7)' and select Start
- once started - attempt to open your database
If this fits/resolves your issue, the service may be stopping due to an update through the Windows Updates/Automatic Updates program. You will want to check your updates and remove any for the SQL Server 2005 program.
06-25-2010 12:53 PM
Thanks for the welcome!
I did get the database to open following your directions. However, I am unable to find any specific SQL 2005 updates. We are running XP so I'm looking in the Add/Remove program list and really the only software updates I see are Security Update for Windows or Media Player. Is there another place I should be looking for the update?
06-25-2010 01:51 PM
06-29-2010 01:54 PM
I've looked there previously and unable to find any list of updates.
I open Control Panel, open Automatic Updates, and it brings up a window that allows me to turn auto update on or off. That's it.
07-05-2010 09:50 PM