Because Timeless Time & Expense 3 and Timeless Project Tracking 3 use a relational database to store information, you can use other tools to do customized reporting. In Personal mode, a MS Access database is used. In Enterprise mode, you may have chosen either an Access or SQL Server database.
There are many different ways to access the data depending on the tool you use. Here are four possibilities. These are general descriptions because different versions of Windows will be slightly different. However, it should be enough information for an experienced developer to accomplish the task.
Using SQL Server
Use a ODBC Datasource
1) Open the ODBC Administrator through the Control Panel. This may be called Data sources and may be under the Administrative tools.
2) Add a new DSN using the SQL Server driver.
3) Select your Instance where you installed the Database.
4) Specify Timeless as the SQL Server database
5) The user id is "TTEguest". Please contact support for the TTEguest password.
Using MS Access
Use a ODBC Datasource
1) Open the ODBC Administrator through the Control Panel. This may be called Data sources and may be under the Administrative tools.
2) Add a new DSN using the Microsoft Access (*.mdb) driver.
3) Select your Timeless.tmd3 as the Database.
4) Select the option to use a System Database and select Timeless.tmw3 from the same directory as in step #3.
5) The user id is "TTEguest". Please contact support for the TTEguest password..
Using Access to Link to or Export data from TT&E - Access does not allow connecting to another Access database through an ODBC datasource. You will need to use the TT&E security database with your other Access database.
1) Create a new database through Access.
2) Close Access and the new database
3) Create a shortcut to the multi-user timeless database with the following target. on one line: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "PathOfNewDatabase/NewDatabase.mdb" /WRKGRP "NetworkLocation\Timeless.tmw3"
4) The user id is "TTEguest". Please contact support for the TTEguest password.
Using ADO in the development tool of your choice
1) Use the following connect string substituting where appropriate.
"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=""NetworkLocation\Timeless.tmd3"";Persist Security Info=False;Jet OLEDB:System database=""NetworkLocation\Timeless.tmw3"";User ID=TTEGuest;Password="
2) Please contact support for the TTEguest password.
To change the guest password (requires MS Access):
1) Create a shortcut to the multi-user timeless database with the following target. on one line: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "NetworkLocation\Timeless.tmd3" /WRKGRP "NetworkLocation\Timeless.tmw3"
2) Open the new shortcut
3) Select the Tools | Security | User and Group Accounts menu item.
4) Select the Change Logon Password tab. Enter the new password.
NetworkLocation = the path to the Timeless.tmd database
*This information is provided as-is. Because of the wide variety of possible tools, MAG Softwrx, Inc cannot assist you with the details of your reporting tool.
*Note - TT&E relies on database being in a predictable, consistent state. If data modifications are done directly, there are no guarantees they are made correctly. Therefore, we do not not allow it and cannot support users who attempt to modify data outside of Timeless.