The SMS Client database can be shared between different users if all the following conditions are met:
Note
When a new release or update of SMS Client is installed the changes to the configuration files have to be made again.
Procedure
1. Create a shared folder on the network.
The shared location should be accessible to all the computers. Ensure that all the users can write to the share. Test the share by copying a file to the shared folder from each of the computers.
2. Copy the SMS Client database to the shared location on the network.
The SMS Client database is displayed on the main screen of SMS Client
3. Update the SMS Client configuration file to point it to the new database location.
Windows XP users: Click on Start->All Programs->Accessories->Command Prompt.
Windows Vista or Windows 7 users: Click on Start->All Programs->Accessories and the right-click on Command Prompt, and click on Run as administrator
cd "C:\Program Files\C.A & W Services CC\SMS Client"
and press enter
copy SMSClient.exe.config SMSClient.exe.config.save
and press enter
notepad SMSClient.exe.config
and press enter
connectionString="Data Source="C:\ProgramData\SMSClient\SMS.sdf""
and replace the C:\ProgramData\SMSClient\SMS.sdf section with the full path for the SMS Client database in the shared folder (Step 2). Do not replace any of the other characters in the string.
Be careful not to change anything else in the file. If this edit is not made correctly then SMS Client will fail to run
Save the file.
4. Run SMS Client and check that the Database information now points to the shared database. (See the picture at Step 2)
Troubleshooting
1. SMS Client fails to start after the edit
This could be the result of the edit of SMSClient.exe.config changing some text or the structure of the file. Restore the backup configuration file:
cd "C:\Program Files\C.A & W Services CC\SMS Client\"
and press entercopy SMSClient.exe.config.save SMSClient.exe.config
Redo the step 1 to 4 and ensure no changes are made except the path to the database.
2. SMS Client cannot connect to the database