ClockReports: Riduzione della memorizzazione dei vecchi dati

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.

Per ulteriori informazioni e indicazioni generali sui nostri prodotti e servizi, si prega di Contattaci.

Hai bisogno di ulteriore supporto?

Cerca tutto Base di conoscenza articoli

Invia un Richiesta di supporto Al Team di Supporto di Idency