Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Compacting IM.MDB after purging the log file

Compacting IM.MDB after purging the log file

TechKnowledge Content

When Log files are Purged from within Integration Manager, it will purge the records from the IM.MDB file. It will NOT, however, shrink the Access database size to reclaim the space used by the log fields. To do this, you will need to Compact the Access database (IM.MDB). The following steps go through how to do this step by step: 

1. Open the ODBC Control Panel (In Windows go to Start - Settings - Control Panel, select the ODBC icon). 
2. Click on the Add button. 
3. Select the Microsoft Access Driver (*.mdb) from the list and click Finish. 
4. Click Compact. 
5. Select the file to compact. This will be the IM.MDB file in your Dynamics\IM directory. 
6. Click OK. 
7. The compacting process creates a new Access database file. Name this new file and click OK. It can be saved into the default directory, which should be the same directory that the IM.MDB file is in. 
8. Through the Windows Explorer, rename the compacted Access database file so that it has the same name as the original file (IM.MDB). 

 Note: To repair the database, repeat steps 1-6. In step 4 click Repair instead of Compact. 

 This article was TechKnowledge Document ID: 9633

↑ Back to the top

Keywords: kb, kbMBSPartner, kbMBSMigrate, BemisKB867174

↑ Back to the top

Article Info
Article ID : 867174
Revision : 4
Created on : 2/27/2017
Published on : 2/27/2017
Exists online : False
Views : 96