Visual Basic Code of the Week (COTW)
Issue #6
All content and source code is Copyright (c) 1997 by C&D Programming Corp. None of the source can be reprinted in any manner without express written permission of C&D Programming Corp.
If you would like to view this page in HTML format, point your browser to

Future Issues

We are currently planning for the next several issues of Code of the Week. If you have any suggestions of source code that you would like to see covered, please jump to our feedback page at and let us know.

Requirements for this Issue

The source code in this issue is designed for Visual Basic 3.0. The techniques should work for all versions of VB 3.0 and greater.

In this Issue

In this issue we are going to show how to add an index to a Microsoft Access database from source code. Similiar techniques can be used to add fields and tables to an Access database.

DBAddIndex function

Function DBAddIndex (sDatabaseName As String, sTableName As String, sIndexName As String, sIndexFields As String, bUnique As Integer, bPrimary As Integer) As Integer

To use this function, just add it to any project or module you are working on and call DBAddIndex as described in the Sample Usage section.


Sample Usage

   Dim bResult As Integer

   bResult = DBAddIndex("C:\REPORT.MDB", "Monthly Budget", "Date Order", "Year; Acct", False, False)
   If bResult Then
      MsgBox "Index appended successfully."
   End If

The above call adds an index called "Date Order" to a table called [Monthly Budget] consisting of the fields Year and Acct. The index added will be a non-unique and non-primary index.

Source Code

To see the source code for this issue you must be a subscriber to Code of the Week. If you are a subscriber the source code is available at the following address:

Comments on the Source Code

This code depends on the feature in Visual Basic that allows you to access all tables as collection. The TableDefs collection has lots of information that can be very useful for your database programming. You can add or delete tables, fields or indexes using this collection of tables. Refer to the Visual Basic help about TableDefs for complete details.

If you have any questions that you can not seem to figure out, drop us a email at and we will do our best to help you out.


That concludes this issue of COTW. We hope you find the source code useful in your development.

The below describes the ways you can supply us some feedback about COTW. We would like to see our members help mold COTW into the best Visual Basic source code resource available. But to do that we need your feedback about what you like and what you do not like about COTW.

How to tell us what you think

If you have any suggestions for topics you would like to see covered or questions about this issue, please email them to or use online feedback form at

If you have any source code you would like to submit for possible inclusion in COTW, please fill out our online submission form at

Contact Information

C&D Programming Corp.
PO Box 20128
Floral Park, NY 11002-0128
Phone or Fax: (212) 504-7945

Subscription Update

Thank you for trying Code of the Week for Visual Basic.

Your free trial expires after you receive your fourth issue. If you want to continue to receive Code of the Week you can get 52 issues of COTW for only $19.95. This is a full year of Visual Basic source code and information to help with all your development. So don't wait, subscribe now! The quickest way to subscribe is to jump to our online order form at

We accept payment by Mastercard, Visa, check or money order. All payments must be in U.S. Dollars. If you are an international customer paying by credit card is usually the easiest method of payment.

If you prefer not to visit our web site:

1. Enclose a note with your email address and name.

2. If you are paying by credit card, make sure you include the credit card number, credit card expiration and name on the credit card and your signature. If you are paying by check, make it payable to C&D Programming Corp.

3. Mail it to (credit card payments can be faxed to (212) 504-7945):
C&D Programming Corp.
PO Box 20128
Floral Park, NY 11002-0128

4. As soon as we receive your payment you will be added to our paid subscriber list.