Compact & Repair Database

#1

Does anyone know of a line of code that I could use to automatically
compact and repair a database, either on a click of a button or
event/action?

#2

This will set the database to compact on exit.......

Application.SetOption "Auto Compact", True

rh

"janthony" <janthony (AT) harrahs (DOT) com> wrote

Quote:

Does anyone know of a line of code that I could use to automatically
compact and repair a database, either on a click of a button or
event/action?

#3

DBEngine.CompactDatabase olddb, newdb, locale, options, password

Hope this helps,

--
Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

"janthony" <janthony (AT) harrahs (DOT) com> wrote

Quote:

Does anyone know of a line of code that I could use to automatically
compact and repair a database, either on a click of a button or
event/action?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Compact & Repair Database

comp.database.ms-access comp.database.ms-access

Compact & Repair Database - 08-06-2003 , 11:29 AM

Re: Compact & Repair Database - 08-06-2003 , 12:38 PM

Re: Compact & Repair Database - 08-11-2003 , 12:50 PM