In maintaining a database who
has access to compact and
repair. should it be only the
administrator?
There is often not "an adminstrator" for an Access/Jet
database. Anyone with exclusive use can compact and
repair. Who _should_ do so will depend on the structure of
the organization who owns the database, and they might
designate someone as "administrator".
Larry Linson
Microsoft Access MVP