ClockReports : Réduction du stockage des anciennes données

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.

Pour plus d'informations et des conseils généraux sur nos produits et services, veuillez Contactez-nous.

Besoin d'aide supplémentaire ?

Tout rechercher Base de connaissances articles

Envoyer un Demande d'assistance À l'équipe de support d'Idency