[ Team LiB ] Recipe Compacting an Access Database Problem You need to compact or repair an Access database. Solution Use COM interop to the compact the Access database using JRO, or the ( ) method to compact the database using a command line switch. | Team LiB Recipe Compacting an Access Database Problem You need to compact or repair an Access database. Solution Use COM interop to the compact the Access database using JRO or the method to compact the database using a command line switch. You ll need a reference to the Microsoft Jet and Replication Objects Library from the COM tab in Visual Studio .NET s Add Reference Dialog. The sample code contains one event handler and a single method Compact Allows the user to specify the Access database to compact and the filename for the compacted Access database. It then calls the CompactAccessDatabase method in the sample to compact the database. CompactAccessDatabase This method uses ADOX through COM interop to compact the specified Access database to the specified location. The C code is shown in Example 10-10. Example 10-10. File Namespaces variables and constants using System using . . . private void compactButton_Click object sender e Create the open file dialog object to get the Access database to compact. OpenFileDialog ofd new OpenFileDialog Set the filter for Access databases. Microsoft Access .mdb .mdb Open the dialog. if Return if not user is not OK. return String sourceFileName Create the save file dialog object to get the filename for the compacted database. SaveFileDialog sfd new SaveFileDialog Set the filter for Access databases. Microsoft Access .mdb .mdb Open the dialog. if If OK selected compact the Access database. Beginning compact. String destFileName Compact the database. try CompactAccessDatabase sourceFileName destFileName Finished compact. catch ex .
