Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Indexs on Tables (Access 2000)

    I am importing data from a text file in to Access. The import
    uses an import spec to control the import.
    The data is being put into a new table. the spec does not list any of the fields as indexes.

    My questions is this. After the import has completed and the table is created, Access then
    creates three indexes on the table.

    Any ideas why this would happen. Also, is there a way to stop the creation of the indexes.


    Thanks
    Richard

  2. #2
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Indexs on Tables (Access 2000)

    Check settings in the Tools>Options>Tables/Queries>"AutoIndex on Import/Create".
    Anything listed there will automatically create indexes upon importing.

    Kwvh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •