Navigation:  Advanced Topics (click to see list) > Time Logger's Databases >

    Time Logger's Databases

Top  Previous  Next

All of Time Logger's data is stored in standard Access (.mdb) format.  All of these files are self-documenting.  That is, the information concerning the database organization (tables, fields, etc.) is present in the files themselves.

NOTE: You can use ODBC to connect to the tables inside the .mdb files.

IMPORTANT: Do not attempt to open the .mdb files in any version of Microsoft Access newer than version '97. When using a newer version of Microsoft Access, use the Link Tables feature (File->Get External Date->Link Tables...) to link to the tables you desire inside the .mdb file.  If you convert the .mdb file to a newer version, Time Logger will not be able to read the data.

IMPORTANT: Be careful not to modify the basic structure of the files, or Time Logger will not be able to read them.

More:

Diagnostics Window

Time Record Database

Descriptor Database

Clients Database

Invoices Database

UserList Database

For example, to see the format of a time record database file, use Microsoft Access version 97 or newer to Link (File->Get External Date->Link Tables...) to your time record database file and select the TimeRecords table.  When you select the TimeRecords table and choose Design, you'll see a window that looks something like this:

DatabaseDesign

You'll notice that we've included comments for any field that is not self-explanatory.  You can see, for instance, that the Billable field is a Yes/No field.

What follows is a brief description of each of Time Logger's database files.