How do I Compact and repair a Jet Database

  1. Home
  2. Knowledge Base
  3. Softalk
  4. Softalk Organizer
  5. How do I Compact and repair a Jet Database

Symptoms

  • The JET Database used by Softalk Collaboration Suite is growing in size and you would like to recover space that is no longer in use in the file.
  • When the Administrator is started you receive the error “Failed to access database!” and the Users and Registration Details are missing.

Resolution

It is recommended to periodically compact and repair your JET database file to help improve performace and to reduce file size by recovering space from deleted items.

If you are having problems with access to the JET data then a compact and repair may correct this.

More Info

Note: This information only applies to Softalk Collaboration Suite, Softalk Mail Server, WorkgroupShare or Softalk Organizer installed to use a JET database.

Detail

  1. Stop any Softalk Collaboration Suite components you have installed. These include the Softalk Mail Server 8.x Server, WorkgroupShare 2.x Server, IIS – if you are running Softalk Organizer – and also the Softalk Mail Server 8.x, WorkgroupShare 2.x and Softalk Organizer administrator programs.
  2. Open the Data Sources (ODBC) applet under Administrative Tools in the
    Control Panel and select the System DSN tab..

    Please Note: If a 64-bit version of Windows is installed then the x86 version of this application must be run from: %SystemRoot%SysWOW64odbcad32.exe instead. If you do not have this folder then you do not have a 64-bit version of Windows.

  3. Click on the SoftalkCollaborationSuite data source and click configure. Check the path and name of the database file on the Configure screen. Open Windows Explorer and make a backup of this file before you continue.
  4. Click the Repair button. The default file name should be the same as the original file, click
    OK to accept this. Once complete a message is displayed to confirm the repair has completed.
  5. Click on Compact. The default file to compact from should be the same file name you have just repaired. Click on
    OK to continue. Also select the same file to compact into and make sure the format is set to Version 4.x (this defaults to 3.x so
    must be changed to 4.x) and click OK. Click Yes to replace the file and wait for the compact process to complete.
  6. Close the Configure dialogue
  7. Reset the permissions to the database thus:
    • Navigate to the folder in which the database file resides as determined
      earlier
    • Right click on the database file (usually SCS.mdb) and select properties
    • Click on the Security tab
    • Click on the Advanced button.
    • Check the Inherit from parent the permission entries that apply to
      child objects. Include these with entries explicitly defined here

      checkbox and click OK.
    • Ensure that the permissions for the following accounts are set:
    •  

      Account Permissions Applies To
      ASP.NET Machine Account (ComputerASPNET) READ/WRITE non-Domain Controllers only
      IIS_WPG (domainIIS_WPG) READ All computers
      Internet Guest Account (ComputerIUSR_computer) READ All computers
      Launch IIS Process Account (ComputerIWAM_computer) READ All computers
      NETWORK SERVICE READ Domain Controllers only

      If the permissions are lesser than that of the above then please
      consult the following FAQ to set them:
      What folder permissions must be set for Softalk Organizer

    • Click OK
  8. Restart the server programs that were stopped earlier.

Was this article helpful?

Related Articles