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.