Connect employee workstations to a Microsoft Access database.  Scroll down for more detailed instructions and a video for connecting to SQL Server.

 

When sharing databases with multiple employees, you have two choices; Microsoft Access and Microsoft SQL. (You can use MS SLQ Express or SQL Server.) If you have more than ten employees who will be sharing the database, you should opt for MS SQL because it is more robust. If you have less than ten employees, MS  Access will be fine. This video shows how to share an MS Access database. Here are the basic steps shown in the video:

    1. Install and run Standard Time® on your local machine
    2. Choose File, Exit before proceeding to stop the app (You cannot just click the red close button.)
    3. Use Windows Explorer to open the “Documents\Standard Time” folder
    4. Copy “Standard Time.mdb” to a file server location where every employee can access it
    5. Make sure every employee has read and write access to the network folder
    6. Open the Control Panel
    7. Open System and Security
    8. Open Administrative Tools
    9. Open Data Sources (ODBC)
    10. Click the File DSN tab
    11. Scroll to the “Standard Time mdb” File DSN and select it
    12. If you are using 64-bit Windows open this version of the ODBC Administrator instead: C:\Windows\SysWOW64\odbcad32.exe
    13. Click Configure
    14. Click Select
    15. Navigate to your file server location (where you copied  the Standard Time.mdb database)
    16. Choose “Standard Time.mdb” from the list
    17. Click OK, OK to close the ODBC Administrator
    18. Restart the app
    19. Repeat these steps on each workstation to connect each employee to the database

Now that all your employees are connected to a shared database, you can begin to set up the product so employees see the shared data on their timesheets.

 

Here are some steps to set up the product:

    1. Choose Tools, Clients to add clients you will do business with

    2. Choose Tools, Projects to add jobs your employees will log time to in the timesheet

    3. Choose Tools, Users and Organization to enter employee logins (normally Windows login names)

    4. Choose Tools, QuickBooks, Import Customers and Items, if you use QuickBooks for billing


Also see: Video: SQL Server Database, Video: Transfer MS Access Database

 

Back to Videos

 

More videos on YouTube

 

 

 

 

 

 

 

    More videos to explore

  • 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
  • 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
  • Interviews (2 - 3 min)

    Interviews about timesheets, project tracking, PTO, and management techniques. Get the general concepts of time and project tracking. Read More
  • 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
  • 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
  • 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
  • Instructional (3 - 6 min)

    Screencast videos with deeper instruction for project management, employee timesheets, PTO, expenses, and client invoicing 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
  • 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?