ClockReports: Reducing storage of old data

How to reduce storage of old ClockReports data

Firstly you should try the below steps as standard:

1. Ensure ClockReports is running as ‘administrator’
2. Click the ‘Data manager’ tab > ‘Data Maintenance’ > ‘Compact Database’

If the database file size has not reduced in size, please also try:

1. ‘Data manager’ tab > ‘Data Maintenance’ > ‘Archive 6 Month Old Records’
2. Then repeat the compact database action outlined above

If the database file size still needs reducing, you can:

1. Click the ‘Data manager’ tab > ‘Custom Query Builder’
2. This will open a new window
3. Copy and paste the following: DELETE FROM CheckInOut WHERE CheckTime BETWEEN #2000-01-01 00.00.00# AND #2019-12-31 00.00.00#;
4. Note that you can change the dates specified
5. Click ‘Execute Query’
6. Then repeat the compact database action outlined above

This should now have reduced the storage being stored in the ClockReports database file. If you have issues with any of the above please contact us.

For more information and general guidance on our products & services, please contact us.

Require further support?

Search all Knowledgebase articles

Send a Support Request to The Idency Support Team