In order to access this database, check your network
connection and verify that your database server is available.
It may be necessary to disable any firewall software".
Sometimes when the computer or server restarts, the services that run in the background on that computer fail to restart. When the SQL Server (ACT7) service does not start, attempting to open your database generates the above error.
Refer back to the opening paragraph and it sets the scene: It's early Monday after a long weekend and/or holiday, and you have not had near enough coffee to deal with this type of computer generated catastrophe. Grab a cup of coffee: You may be able to fix this!
Your next action is dependent on the number of users in your database, and their status.
* Is it just you? Move on to Step 1 outlined below on your computer.
* Do others in your office access the same database?
- If others can access the database, move on to Step 1 outlined below on your computer.
- If others cannot access the database from their workstations either, go to the Server hosting the database to accomplish these steps:
1. In the Start Menu (or Search in Windows 8) type "services.msc" and hit Enter. This will open a list of services operating on that machine (as shown in the graphic below).
2. Scroll down the list of services to find "SQL Server (ACT7)" Select it to hi-light it.
3. Select "Start" (or "Restart") in the top left.
OPTION: You may Right Click "SQL Server (ACT7)" and select Start or Restart.
Once that SQL service is restarted, your database should open. (Disclaimer: The error can be caused by other issues, but this is the most frequent cause, especially on Monday mornings in databases that were working perfectly on Friday!)
Version 16 actually starts SQL for you, instead of giving a "generic" error.