Re: indexes in MsAccess

From: Evelyn V Stevens (evelyn_at_intention.nss.udel.edu)
Date: 12/17/04

  • Next message: Luke Webber: "Re: TOMCAT/MYSQL/JSP" 
    Date: Fri, 17 Dec 2004 22:12:54 +0000 (UTC)

    Hi,

    The un-named index -probably- defaulted to the column name. If that
    doesn't work in your ALTER TABLE statement, see whether you can find the
    name by using the Documenter in Access:

    Tools
      Documenter
        Tables (select only the table in question)
          Options (turn off all options (set to None) except Names and
                    Properties under Indexes - otherwise the documenter
                    returns way too much data)

    Hope this helps,

                                            Evelyn 

    -- 
Evelyn V. Stevens, Ph.D.      		E-mail: evelyn@udel.edu 
Information Technologies-User Services 	
U. of Delaware, Newark, DE 19716	Phone:  302-831-4240
  • Next message: Luke Webber: "Re: TOMCAT/MYSQL/JSP"