Results 1 to 2 of 2

Thread: create autoincrement field via jet 3.5

  1. #1

    Thread Starter
    Addicted Member c@lle's Avatar
    Join Date
    Oct 1999
    Location
    Belgium
    Posts
    179

    Unhappy create autoincrement field via jet 3.5

    how can i create an autoincrement field via a connection using the jet 3.5 database engine?

    this is my connection string
    Code:
    objDB.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & strFileName
    i've found information about jet 4.0 and then setting 'autoincrement' on the properties,

    but how can i do this in jet 3.5??

  2. #2
    -= B u g S l a y e r =- peet's Avatar
    Join Date
    Aug 2000
    Posts
    9,629
    VB Code:
    1. Dim SQL As String
    2.  
    3. SQL = "ALTER TABLE Table1 ADD COLUMN ID COUNTER"
    4. objDB.Execute SQL

    that any good ?
    -= a peet post =-

Posting Permissions

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



Click Here to Expand Forum to Full Width