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.

Details
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 8,969 times.
Options