ClockReports: A reduzir o armazenamento de dados antigos

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.

Para mais informações e orientações gerais sobre os nossos produtos e serviços, por favor Contacte-nos.

Necessita de mais apoio?

Pesquisar tudo Base de conhecimento artigos

Enviar um Pedido de suporte Para a Equipa de Apoio da Idency