Is it necessary to compact / run maintenance on an Access 2007 DB?

[MLyons10]

Hello, I am developing an application that uses a Microsoft Access 2007
Database. I was wondering if it is necessary to have my application compact
or run maintenance on the Access 2007 Database, and if so how often, or how I
would know if maintenance was necessary...

Any help and information is greatly appreciated.

Thanks Again,

 

[david]

No, if it is necessary to compact on a regular basis, you should
consider re-design of the application, perhaps using an external
database for temporary tables.

Deleted records are not removed until you compact, and tables
are sorted into primary key order when you compact. If your
application depends on either of those, you should consider how
you can re-design.

For most applications, compact or repair should not be a requirement.

(david)