TADMSAccessService.Compact Method

Compacts an Access database.

Group

Links

TADMSAccessService Class, TADMSAccessService Members, uADPhysMSAcc Namespace, Example 1, Example 2, Example 3, public, See Also

Description

Use the Compact method to compact a database. To run Compact, an application must specify:

Database - the source database file name;
DestDatabase - the destination database file name. If it is not specified, then DestDatabase is equal to Database.

Optionally Encrypted, Password and SortOrder may be specified.

The file pointed by Database must be a valid .MDB file. DestDatabase can point to the same file as Database, in which case the file will be compacted into the same location. If DestDatabase names a different file than Database, the file named as the DestDatabase will be deleted at the time Compact is called. When the operation fails, then EMSAccessNativeException exception is raised.

Syntax

procedure Compact;

Example 1

// Compact non-secured database
ADMSAccessService1.Database := 'c:\test.mdb';
ADMSAccessService1.DestDatabase := 'c:\test2.mdb';
ADMSAccessService1.Compact;

Example 2

// Compact secured database
ADMSAccessService1.Database := 'c:\test.mdb';
ADMSAccessService1.Password := 'J@^^1234pw';
ADMSAccessService1.Compact;

Example 3

// Reset password of secured database
ADMSAccessService1.Database := 'c:\test.mdb';
ADMSAccessService1.Password := 'J@^^1234pw';
ADMSAccessService1.ResetPassword := True;
ADMSAccessService1.Compact;

What do you think about this topic? Send feedback!