pcsoft.us.windevCopyright 2026, PC SOFT20 Oct 2016 17:38:00 Z17 Oct 2016 23:17:00 ZHi All, I have an application that is connected to an MDB file using native connectivity on Windev 21. The MDB database has only a single table which is overwritten with data on a regular basis and never holds more than 500 records. It is a very simple flat record database. The issue is over time the physical size of this database grows larger and larger 10's of MBytes. Performing a compact and repair from MS Access brings the database back down to under 1MB. The target audience for this application may not have MS Access installed but will need the access database type for connection to third party applications, however the growing file size is a concern. Is there a way from Windev to perform a compact and repair on an MDB file to reduce this growing size? Thank you for your time :) R L Solutions Ltd Barcoding and Labelling Solutions www.rlsltd.co.uk30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60062/read.awp20 Oct 2016 17:38:00 ZHi All, In conclusion the target clients for this application may not have MS Access installed on their computers and the com…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60062/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60062/read.awpMDB Compact & Repairguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60030/read.awp18 Oct 2016 13:34:00 ZHi José , Thank you for your suggestion, this is a great fallback option if I am unable to compact and repair on close. Wi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60030/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60030/read.awpMDB Compact & Repairguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60027/read.awp18 Oct 2016 13:30:00 ZHi Guenter, Thank you for pointing this out, I had come across this before but I assumed (probably incorrecrtly) that the com…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60027/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60027/read.awpMDB Compact & Repairguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60022/read.awp18 Oct 2016 08:50:00 ZYo can also have a second blank .mdb. Then Copy the records and replace the main file when needed. Regards, José Antonio.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60022/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60022/read.awpMDB Compact & Repairguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60021/read.awp18 Oct 2016 08:26:00 ZHi Lee, you can automatically compact & repair an Access database whenever it is closed https://support.office.com/en-us/a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60021/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60020-mdb-compact-amp-repair-60021/read.awpMDB Compact & Repair