Change index from No duplicates to duplicates allowed

Discussion in 'Microsoft Access Form Coding' started by ReidarT, Jun 4, 2004.

  1. ReidarT

    ReidarT Guest

    How do I change Change index from No duplicates to duplicates allowed
    in a table with DAO.
    regards
    reidarT
     
    ReidarT, Jun 4, 2004
    #1
    1. Advertisements

  2. ReidarT

    Allen Browne Guest

    I believe you have to delete the Index from the Indexes collection, and
    create another one with the characteristics you want.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "ReidarT" <> wrote in message
    news:%...
    > How do I change Change index from No duplicates to duplicates allowed
    > in a table with DAO.
    > regards
    > reidarT
     
    Allen Browne, Jun 4, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jesper F

    Are " not allowed in SQL?

    Jesper F, Jul 4, 2003, in forum: Microsoft Access Form Coding
    Replies:
    4
    Views:
    451
    Jesper F
    Jul 5, 2003
  2. JT

    Access 2003 - only default font allowed in vertical text

    JT, Mar 5, 2004, in forum: Microsoft Access Form Coding
    Replies:
    0
    Views:
    192
  3. Amir
    Replies:
    2
    Views:
    422
  4. Guest

    Index (no duplicates)

    Guest, Apr 6, 2005, in forum: Microsoft Access Form Coding
    Replies:
    1
    Views:
    126
    Ken Snell [MVP]
    Apr 6, 2005
  5. lindavon81

    Code to temporarily change "no duplicates allowed" property

    lindavon81, Jun 26, 2008, in forum: Microsoft Access Form Coding
    Replies:
    3
    Views:
    232
    UpRider
    Jun 27, 2008
Loading...

Share This Page