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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLyons10 - 29 Jan 2008 01:33 GMT

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,

Reply to this Message

david - 29 Jan 2008 05:45 GMT

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)

> Hello, I am developing an application that uses a Microsoft Access 2007
> Database. I was wondering if it is necessary to have my application
[quoted text clipped - 6 lines]
>
> Thanks Again,

Reply to this Message