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.
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:
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.