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

For MS Access Databases, Also See: Video: Transfer MS Access Database, Video: Connect Timesheet to MS Access

 

Back to Videos

 

More videos on YouTube

 

 

 

 

 

 

 

    More videos to explore

  • Quick Questions (2 - 4 min)

    Answers to quick questions we have received regarding the employee timesheet, projects tracking, and PTO. See the product in action. Read More
  • Whiteboard (60 sec)

    Introductions to time tracking and project management. Get ideas, get inspired, try new things, and learn what your timesheet can do Read More
  • Instructional (3 - 6 min)

    Screencast videos with deeper instruction for project management, employee timesheets, PTO, expenses, and client invoicing Read More
  • Cartoons (60 sec)

    The lighter side of time tracking and project management, in cartoon format. Learn what the makers of Standard Time really think! Read More
  • Interviews (2 - 3 min)

    Interviews about timesheets, project tracking, PTO, and management techniques. Get the general concepts of time and project tracking. Read More
  • Old-Timey (60 sec)

    Tracking time and expenses in the modern world? See the most modern technique for time sheets and time management Read More
  • Short Intros (60 sec)

    Short intros to the basics of time tracking and project management techniques. Learn how employees use the timesheet. Read More
  • Animated (30 sec)

    Introduce and inspire use of the timesheet and project management techniques. You will learn what can be done and be tempted to try it. Read More
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

 

FREE TRIAL


Download a fully functional timesheet that will remain active for 30 days.
Company Name
Please enter your company name
Full Name
Please type your full name.
E-mail
Invalid email address.
Number of Employees
How many employees will use this?
Enter the text below
Enter the text below
Please enter the text above