Name

dbengine.CompactDatabase(olddb, newdb, [locale]), [options] , [password])

Synopsis

Copies and compacts a database. The database must be closed.

Argument

Description

olddb

The name and path of the existing database file.

newdb

The name and path of the compacted database file.

locale

An optional collating order used in creating the compacted database file. See DAO Help for more information about collating order settings.

options

A combination of constants that specify characteristics of the recordset. See DAO Help for more information about these options.

password

An optional password string.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.