'Create the table
sSQL = "CREATE TABLE certificates ( " & _
          "cert_id INT IDENTITY (1,1) NOT NULL," & _
          "user_id INT DEFAULT 0 NOT NULL," & _
          "cert_type VARCHAR(15) DEFAULT '' NOT NULL," & _
          "cert_type_id VARCHAR(15) DEFAULT '' NOT NULL," & _
          "industry VARCHAR(15) DEFAULT '' NOT NULL," & _
          "date_first_print DATETIME DEFAULT '1900-01-01 00:00:00' NOT NULL," & _
          "date_last_print DATETIME DEFAULT '1900-01-01 00:00:00' NOT NULL," & _
          "date_cert_issued DATETIME DEFAULT '1900-01-01 00:00:00' NOT NULL)" & _
oCon.execute(sSQL)
' turn on identity insert
oCon.execute("SET IDENTITY_INSERT certificates ON")
' insert my starting value -1 - I want to start at 10000
oCon.execute("INSERT INTO certificates (cert_id) VALUES (9999)")
' turn off identity insert
oCon.execute("SET IDENTITY_INSERT certificates OFF")
' now delete my seed record
oCon.execute("DELETE FROM certificates")
' the next record to be inserted will have an identity of 10000!