Move your MS Access database from one machine to another.  Scroll down for more details.

 

How to transfer your Microsoft Access database from an old machine to a new one:

 

Step 1: Install Standard Time

Begin by installing the product onto your new machine.  Start it up and make sure there are no errors or problems.  You should be able to choose File, Exit and restart the app without any trouble.  At this point the database will be empty, but you’ll soon copy your database from the old machine to the new one so don’t worry about that yet.

 

Step 2: Check your username

Start ST on both the old and new machines.  Look closely at the username displayed in the upper-right corner of the main window on both programs.  That username on the new machine should match your old machine.  If it does not, choose Tools, Users and Organization to change it.  It is important to use the same name because your data is tied to this username.

 

Step 3: Exit ST

We’re about to copy the database, so you must shut down the program on both the old and new machines.  Choose File, Exit to do that.  Make certain both programs are shut down.

 

Step 4: Copy database

The database will be named “Standard Time.mdb” and will be located in Documents\Standard Time.  The old database will likely be located in the same folder on the old machine.  Copy this old database to the same location on the new machine.  This is a folder location you should back up every day.  If you lose this file, you will have to start with an empty database.  Best to back up.  Checking the modification date on the database file will help verify that it is the correct file.

 

Step 5: Restart ST

Now that the database is in the proper location, you can simply restart the app.  You will see all your projects in the timesheet and all your old time log records in the Time Log view.  Choose Tools, Projects to verify that your projects are there.  If you don’t see them, something probably went wrong with the database copy.  Verify the size and modification date on both the old and new database.  They should be the same.  Also verify that you are using the same username on both the old and new machines.

 

Advanced steps for databases on a file server:

Most users will not need to follow these steps.  These are advanced steps only used with your database is not in the default location (Documents\Standard Time).  If your database is located on a file server, these steps will help you point your workstation to the database.

 

64-bit users:

If you are running 64-bit Windows, the first four steps below are replaced by finding and running the 64-bit program below.

C:\Windows\SysWOW64\odbcad32.exe

 

Step 1: Open the Control Panel (32-bit Windows only)

Step 2: Open System and Security (32-bit Windows only)

Step 3: Open Administrative Tools (32-bit Windows only)

Step 4: Open Data Sources (ODBC) (32-bit Windows only)

Step 5: Click the File DSN tab

Step 6: Click on your File DSN and click Configure

Step 7: Click Select

 

Here you can navigate to the location on your file server where your database is.  Simply find your database, click on it, and click OK to save the setting.  The program will use this path when accessing the database.  After pointing your File DSN to the database on your server, you can restart ST to access it.

Also see: Video: Connect Timesheet to MS AccessVideo: SQL Server Database

 

Back to Videos

 

More videos on YouTube

 

 

 

 

 

 

 

    More videos to explore

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

    Interviews about timesheets, project tracking, PTO, and management techniques. Get the general concepts of time and project tracking. 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
  • 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?