Connect your employee workstations to a SQL Server or SQL Express database. Share all your timekeeping data. Scroll down for more details.
Standard Time® works with Microsoft SQL Express® and Microsoft SQL Server® databases. SQL is recommended for companies larger than ten employees, or companies desiring a mission critical database to connect the product to.
You may have noticed that the default installer uses a Microsoft Access® database that is installed onto your local hard drive. The MS Access database is located in Documents\Standard Time. This is fine for evaluation, testing, and single-user accounts, but should be migrated to MS SQL Server for larger installations. The steps to connect to SQL Server are in this video.
For expediency, we've copied the steps to connect to SQL below.
1. Open MS SQL Server (or SQL Express)
2. Make sure you have an ST database to connect to (create one, if necessary)
3. Make sure you have a "st" login that has db_owner rights to the database
4. Allow Remote connections to the server
5. Open the Control Panel, System and Security, Administrative Tools, Data Sources (ODBC)
6. Click the File DSN tab
7. Create a File DSN that connects to your database in SQL Server
8. Open ST and choose File, Database 9. Enter the File DSN name and click OK to restart
Large organizations should also consider adding indexes to the database. Indexes improve database access and make the program faster. But they are normally not necessary until you have over 100 employees accessing the system. In that case, indexes can be placed on all GUID columns in all tables. GUID columns are the primary keys for every table. In addition to these, consider adding foreign keys from all the ID columns to GUID columns. Examples are Tasks.ClientID --> Client.GUID, Tasks.UserID --> Users.GUID, and Tasks.CategoryID --> Categories.GUID. Follow this convention to add foreign keys from all the ID columns in all the tables to the GUID columns.
In addition to GUID keys, consider placing indexes on all date columns. Indexing by dates helps the program obtain lists of records in date order. Many queries in the program use dates.
Also See: Video: Setup Web Timesheet