There is more than one possible cause for this issue:
- Unshared Database
- Multiple Shares on Database Files Folder
- Windows File and Print Sharing Service Not Running
- Security of the Shared Folder
- Pad File Issues
- Password Protected File Sharing (Windows Vista and later)
Ensure that you have enabled the Share Database option. Use the following steps:
- Launch ACT!, and open the desired database.
- Click the Tools menu, point to the Database Maintenance option, ensure that there is a check to the left of the Share Database option; if not, click this option to enable it.
Note: If share option is currently enabled: click on it to disable, close and reopen the database, then click on the share option to enable it.
Multiple Shares on Database Files Folder
This error can occur if there are multiple shares on the your ACT! database files folder. To check this:
- Ensure that you are logged into the machine hosting the database as an Administrative user with full permissions and access.
- In ACT!, Go to Tool/Database Maintenance and, if Share Database is checked, then click it to uncheck.
- Close ACT!
- Right-click on My Computer on your Desktop or from your Windows Start menu, and select Manage.
- In the Computer Management console, expand Shared Folders on the left side, then click on Shares underneath it.
- In the list of shared folder on the left, look to see if your ACT! database files are listed more than once.
- If you see more than one shared instance in the list, then right-click on each instance and select Stop Sharing, until you have unshared all instances of your ACT! database files.
- Re-open ACT! and go to Tools/Database Maintenance and select Share Database to re-share it.
- Have your users open ACT! and attempt to access the shared database
Windows File and Print Sharing Service Not Running
To ensure that the Windows File and Print Sharing service is Started in the Services dialog box on both the server and client computers, follow these steps:
- Click the Windows Start button, then click Run. The Run dialog box appears.
- Type services.msc into the Open field, then click OK. The Services panel appears.
- Find the Server entry in the Name column, and ensure that Started is displayed in the Status column.
- If not; right-click Server, click Start from the shortcut menu, and then close the Services dialog box.
- If the Server service displays Started, close the Services dialog box.
In an active directory environment, it may be necessary to add the remote user names to the security tab for the shared folder and to ensure that these remote users have appropriate permissions.
- From the computer hosting the shared database, launch Windows Explorer (or My Computer) and navigate to the shared folder.
- Right-click the shared folder, and then click Properties from the shortcut menu. The folder Properties dialog box appears:
- Ensure that the Share this folder option is enabled and that the User limit is sufficient to allow all desired users to share the folder. Click the Permissions button. The Permissions for the shared folder dialog box appears.
- It is recommended the user named Everyone have Full Control permissions to the shared folder. In some cases, it is necessary to add the specific names of the remote users to this Share Permissions list, to ensure that each domain user has Full Control of the shared folder.
For detailed information on adding specific domain users to the Share Permissions list, please contact your network administrator or Microsoft.
Pad File Issues
This error can also result if the .PAD file that you are using to access the shared database is damaged, not configured properly, or if your network has difficulty resolving the Host name in the .PAD file for this database. This issue can be corrected by editing the .PAD file with the actual IP Address of the Host computer.
You can rebuild your .PAD file. Use the following steps:
- Launch Window Explorer (or open My Computer).
- Browse to and delete the .PAD file associated with your database (normally C:\Documents and Settings\<user_name>\My Documents\ACT\ACT for Windows 9\Databases). If you database is named Contacts your .PAD file will be Contacts.pad.
- Close Windows Explorer (or My Computer).
- Launch ACT!. If presented with the login dialog box, click Cancel to close.
- Click the File menu, and then click Open Database. The Open dialog box appears.
- Click ACT! Database (*.ADF) from the Files of type drop-down.
- Click the .ADF file associated with your database, (if you database is named Contacts your .ADF file will be Contacts.adf) and then click Open. Login if needed. This will recreate the .PAD file.
If this does not resolve your issue, then continue to the next step.
You can modify your .PAD file to use the IP Address of the computer hosting the shared database instead of the computer name. This is a two step process that requires you modify the .PAD file at the computer(s) attempting to open the shared database and modify the Naming Method in the shared database. Use the following steps:
Warning: If the IP Address of the Host computer is subject to change, you must edit the .PAD file each time the IP Address changes.
Modifying the .PAD File:
- Launch Windows Explorer (or My Computer).
- Navigate to the location of your .PAD file (normally C:\Documents and Settings\<user_name>\My Documents\ACT\ACT for Windows 9\Databases).
- Right-click the .PAD file in this directory, and then click Open With from the shortcut menu.
- Open the file with Notepad. Notepad launches with the .PAD file information.
- Select the information between the quotes at the host=location, this is the name of the computer hosting the shared database.
Note: If the host= displays "."; the original database is not shared. A database Administrator must login to the database you wish to share, click the Tools menu, point to Database Maintenance and then click Share Database. Creating another copy of the .PAD file after the database is correctly shared will resolve this issue in most cases.
- Type in its place, the IP Address, then a comma and the SQL Port number for the computer that is hosting the actual ACT! database files (example: 10.30.9.124,2417). For instructions on determining the IP address for a computer or determining the SQL Port being used on the computer, click the appropriate link below:
How to determine the IP address for a computer
- Click the Windows Start button, and then click Run. The Run dialog box appears.
- Type cmd into the Open field, and then click OK. The DOS command prompt appears.
- Enter ipconfig at the command line, and then press your Enter key. The IP address is displayed in the command window.
- Click your Windows Start button, then click Run. In the Open box, type in actdiag and click OK. Windows Vista users do not need to click Run...just type actdiag in the Search box at the bottom of the Start menu.
- ACT! Diagnostics will open.
- On the left side, click Server, then click Server Security.
- When the security screen comes up, you will the port number in the TCP/IP Port box.
- On the Server Security screen (to the right of the port number box), click on Server Configuration Manager.
- On the SQL Server Configuration Manager screen, in left column, expand SQL Server Network Configuration.
- Left click on Protocols for ACT7 to select.
- In right column, right click on TCP/IP tab and select Properties.
- On TCP Properties screen, click on the IP Addresses, scroll to bottom and locate TCP Dynamic Ports. This is the port number to enter as an exception.
- Once you have edited the host name appropriately, make no other changes to the text, click the File menu, and then click Save.
- Close Notepad.
At the computer hosting the shared database you must change the Naming Method from Machine Name to IP Address for the shared database:
- At the computer hosting the shared database, click the Windows Start button, and then click Run. The Run dialog box appears.
- Type actdiag in the Open field, and then click OK. The ACT! Diagnostic tool launches.
- Click the Database button in the left navigation bar. The Database list appears.
- Click the rectangle to the left of the shared database.
- Click the Actions menu and then click Datastore Location. The Datastore Management dialog box appears.
Note: In Sage Act! 2011, this option is located on the Actions menu, then select Datastore Location.
- Click the IP Address option, click the IP Address to select it, and then click OK.
- Close the ACT! Diagnostic tool.
If you are experiencing this error and the machine hosting the database is using a Windows Vista or later operating system, it could be the result of the Password Protected File Sharing security feature being enabled. We recommend that you communicate with your network administrator before making any modifications to this feature. For more information on this topic, please refer to the following third-party document: Password Protected File Sharing in Windows Vista
If you cannot or do not wish to disable Password Protected File sharing, you can work around it by using the following steps from the workstation experiencing the issue:
- On your keyboard, press the Windows key + R
- Type \\[servername] in the run dialog box and press Enter
- When prompted for the username and password, enter the Windows Administrator username and password for the server
- Check the box to remember the credentials
- Click OK
- Attempt to open the database again
Note: You may also wish to do this with the server IP address as well, as sometimes the server name will not prompt for a username and password, but the IP address will prompt for the username and password