Execute the following steps to install At Your Service for multiple users on a local area network:
1. If you are installing the Repair SQL or Retail SQL edition then either MySQL 5.0 or later, or Microsoft SQL Server 2000 or later (desktop, express, or server edition) must be installed on one of the network servers or workstations (see Installing MySQL, and Installing Microsoft SQL Server Express). Ensure that users have the necessary security rights configured to access the SQL server (see Creating a New Empty MySQL Database, and Creating a New Empty Microsoft SQL Server Database).
2. Install the program on each workstation using the steps outlined in the previous section (see Installing on a Workstation). All users must have the same program version installed.
3. If working with a Microsoft Access database then create and save your database to a folder on a shared network drive (see Creating a New Empty Access Database) and ensure that all users have full access to that folder from their respective workstations. If working with a SQL database then create the database (see Creating a New Empty MySQL Database, or Creating a New Empty Microsoft SQL Server Database) and ensure that all users have security access to the database from their respective workstations (see Configuring User Security on Microsoft SQL Server).
4. On each workstation, run At Your Service (see Running the Program), select File Open Database from the main program menu and navigate to the shared network folder or the SQL server to find and open the database (see Opening an Existing Access Database, Opening an Existing MySQL Database, or Opening an Existing Microsoft SQL Server Database).
NOTE Ensure that both wired and wireless network cards and devices are configured to not go into any kind of “sleep” mode when there is a lull in network activity. This can cause the software to disconnect from the database.
NOTE While At Your Service Software, Inc. is providing a limited amount of technical information here to assist you in setting up your network and communications systems, it is ultimately the responsibility of you and your company to work along with your network technicians and consultants to evaluate, select, install, test, and maintain these systems.
(See also Optimizing a Network for Speed.)