Frequently Asked Questions

SwiftTec > Support for SwiftTec Products > Frequently Asked Questions

Category: SwiftTec Software

Problem

When starting the software you are presented with a dialog box that prompts you for a data source.

Solution #1 (Microsoft Access is available)

  • Make a copy of the membership database (membership.mdb)
  • Attempt to open the database using Microsoft Access.
  • If Microsoft Access opens the database without complaining then the database is not corrupted
  • If prompted to repair the database select Yes
  • Close the database
  • Re-run the software which should no longer prompt for for the data source.

Solution #2 (Microsoft Access is NOT available)

  • Download the Jet Compact Utility from http://support.microsoft.com/kb/273956/EN-US/
  • Run the JetComp utility on the membership database saving it to a new name (membership-compact.mdb)
  • Rename the corrupt database as membership-corrupt.mdb
  • Rename the new database as membership.mdb
  • Re-run the software which should no longer prompt for for the data source.
Category: SwiftTec Software

Problem

You want use the member details (name, address, etc) contained in the Club Membership System for creating an mail merge.

Applies To

Solutions

There are 2 ways of solving this problem, but the best way is to export the details into a CSV file

Preferred Solution – Export the details into a CSV file.

  • Start the main CMS program
  • Select reports
  • From the Member Reports tab select the criteria you want to select the members and select which fields you want to display
    (Remember to select the m_address field if you want to include the member address).
  • Press the OK button – this will produce the report From menu select File/Save As Save the file under the folder and name you require
  • You can use the CSV file as input to the MS Word mail merge

Alternate Solution (MS Access Databases Only) – Link directly to the database from MS Word

  • Start the CMS Admin Tool and select the Data Folders tab
  • Copy the contents of the Main data directory – this is where the membership database is stored.
  • In MS Word start the mail merge process.
  • When you come to the section which allows you to pick the recipients select Browse or Use existing list
  • Paste the folder name into the Select Data Source dialog box and press Open
  • In that folder select the membership.mdb access file. (Note the .mdb may not be shown)
  • Select the member table
  • You can then select the members and fields you wish to use in the mail merge