Compact Table (1 Viewer)

[smed]

Does anyone know of a way to compact a linked table ?

Smed

 

[DBL]

You could put this on the On Click event of a command button:

DBEngine.CompactDatabase "C:\My Documents\Nameofdatabase_be.mdb", "C:\My Documents\Nameofdatabase_be1.mdb"
Kill "C:\My Documents\Nameofdatabase_be.mdb"
Name "C:\My Documents\Nameofdatabase_be1.mdb" As "C:\My Documents\Nameofdatabase_be.mdb"

Obviously you'll need to specify the exact file path to the backend.

HTH

 

[smed]

Thanks, that works perfect !

I have another related question, do you know how to compact data in different format (e.g. dbase, paradox) ?

Smed