Product Family: Act!
Product: Act! Pro, Act! Premium
Cause: This can occur if the file path or Windows user name contains an apostrophe or hyphen. This can also occur if there is damage to the database.
This error will result if the database was saved to your Windows desktop upon creation, or if the file path or Windows user name contains an apostrophe (or hyphen). You must move the database files to a folder off your desktop, or away from the file path containing the apostrophe, in order to create a Back Up or Save Copy As. This process will require that you detach your database from the ACT! instance of the SQL Server, copy the database files to the new location, and then reattach your database to the ACT! instance of the SQL Server.
Use the following steps:
Note: Images in your version of ACT! may differ slightly from the ones used in this Answer.
- Close ACT!
- Click Start, and then click Run. The Run dialog box appears.
- In the Open field, enter
actdiag (ACT! 2007 and later), act8diag (ACT! 2006), or
act7diag (ACT! 2005), and then click
OK. The ACT! Diagnostics
- Click the Databases
from the navigation bar. A list of your databases will appear.
Note for Sage ACT! 2011 Users: The "Database" and "Server" options have been relocated to the top toolbar. The following steps are the same regardless of what version of ACT! you have installed.
- Click the rectangle on the left side of the DATABASE name that you wish to Detach. The entire row displaying the database information becomes selected.
- Note the path in the DATABASE FILE LOCATION column.
- Right-click the rectangle on the left side of the
DATABASE name, and then click
Detach Database from the shortcut menu. The following
Detach Database dialog box appears.
- Ensure that this dialog box reflects the correct database
name, and then click Yes. The following
Detach Database window appears.
- Click OK. Your database is detached from the ACT! SQL Server Instance.
- Launch Window Explorer (or My Computer).
- Navigate to the location noted in step 6.
- Copy the .ADF and .ALF files along with the database files folder associated with your database. If the name of your database is Contacts then you would copy Contacts.adf, Contacts.alf, and Contacts-database files.
- It is recommended that you create a folder on your computer named ACT Database.
- Paste the two files and folder that you copied in step 12 into this new folder.
- Launch ACT!. Click the File menu, and then click Open Database. An Open dialog box appears.
- Change theFiles of Type
field to ACT! Database (*.ADF) (as illustrated
- Navigate to the folder you created in step 13. Open your
database by double-clicking the .ADF file.
Opening your ACT! 2005 database after detaching it will force it to reattach
to the ACT! instance of the SQL Server. The following
ACT! dialog box appears.
- Click OK to began the
verification of your database. The following ACT!
dialog box appears.
- Click OK to open your database.
If the above steps do not resolve the issue, it may be possible that the database is damaged. You may be able to resolve the issue by running maintenance on the database. Follow the steps below:
- Stop the SQL Server (ACT7) instance. For more information, refer to the following knowledgebase article:
How to Stop or Start the SQL Server® ACT7 Instance
Answer ID: How to stop or start the Microsoft SQL Server (ACT7) instance
- Copy the database files to another location to serve as a precaution
- Run full database maintenance. For more information, refer to the following knowledgebase article:
ACT! Database Rebuild and Repair Procedures
Answer ID: Act! database rebuild and repair procedures
- Attempt creating the backup again to test