Results 1 to 7 of 7

Thread: Create CONSTRAINT (not unique)

Threaded View

  1. Sep 21st, 2007, 11:52 AM #1
    dw85745
    dw85745 is offline

    Thread Starter
    PowerPoster
    Join Date
    Jul 2001
    Location
    Tucson, AZ
    Posts
    2,166

    Resolved Create CONSTRAINT (not unique)

    How do you create a CONSTRAINT (index) for Access in SQL that is NOT:
    1) a PrimaryKey
    2) or UNIQUE

    In other words I want a DateTime Index where the date may appear more than once.

    ============
    These work:

    & "CONSTRAINT PrimaryKey PRIMARY KEY (fldID)), " _
    & "CONSTRAINT idxDateTime UNIQUE (fldDateTime));"


    ==============================
    This fails:

    & "CONSTRAINT idxDateTime (fldDateTime));"
    Last edited by dw85745; Sep 21st, 2007 at 12:25 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width