You are trying to change the datastore location of your ACT! database in ACT! Diagnostics when you see that after the changing the location to the IP address of the machine, that datastore location results in the name of the database being changed to or including the IP address of the machine you are on.
This can occur if the name of your database includes the machine name of that computer. This is a reported issue. To work around this issue you will need to change the name of your database so it does not include the machine name of the computer hosting the database. Follow these steps to rename your database:
- Make a backup of your database in ACT!.
- Close ACT! on the host machine, and if this is a shared database, have all users close ACT! on their machines as well.
- On the machine hosting the database, right click the Windows Start button. Click Run Type in actdiag and press OK.
- Be sure that you know the filepath to your database on this machine.
- In the ACT! Diagnostics utility, click Databases, then Database List. A list of local databases will appear.
- Locate your database on the list, click to left of it to highlight it, then right-click on the database and select Detach Database. Click Yes when prompted.
- When the database has been detached, you will get an acknowledgement, and the database will disappear from the list. This does not mean your database has been deleted, only that it has been detached from the SQL Server. This is necessary in order to be able to edit the database name.
- Close ACT! Diagnostics.
- Open Windows Explorer and browse to the location of your database.
- Delete the .PAD file for your database (i.e. [database name].pad).
- For the .ALF, .ADF, and [database name]-database files folder, change the machine name part of the database name to something else. Be sure the name matches exactly for all three files.
- Open ACT!. You will get a message that the last database could not be found. Click OK and browse to the location of your database in the Open screen.
- On the Open screen, change the File Type dropdown to .ADF. You will see the newly named .ADF files for your database. Double-click on it to open.
- You will get a message that the database will be verified. This means that the database is being reattached to the SQL Server.
- When the database has been reattached, it will open up under the new name.
- You can now go back into ACT! Diagnostics and change the Datastore Location.