Knowledge Base

Convert Access TT&E database to SQL Server

Expand / Collapse

Convert Access TT&E database to SQL Server

As your business grows you will want more users to track their time and expenses on more projects.  As the demand increases, you may find the multi-user Access database is not performing as well as you would like.  Access is limited in its ability to support a high number of users.  SQL Server or MSDE can support more users. 

To convert your Access Timeless Time & Expense database to SQL Server or MSDE, you must first create a SQL Server Timeless database as specified in this article

Next, run the Timeless Access to SQL Server (or MSDE) database conversion.  You must have already upgraded your access database to version 2.x to use this utility. 

During the conversion, user passwords will be reset.  You will have to reset the user passwords after conversion. 

You should not run Timeless Time & Expense before running the conversion.  If you do, DO NOT create sample tasks - the target database must be empty.

Finally, re-install each Timeless Time & Expense Enterprise on each pc, selecting the new database type and location.

Rate this Article:

Add Your Comments

Comment require login or registration.

Last Modified:Wednesday, March 21, 2007
Last Modified By: MAG Softwrx, Inc
Type: INFO
Rated 4 stars based on 2 votes.
Article has been viewed 10,949 times.