I'm using VS2017, so if you aren't, I could see how you may have issues. The newer software is more lenient. For example, this works in VS2017:
Using cnn As New SQLiteConnection(connBuilder.ToString())
Using Comm As New SQLiteCommand()
With Comm
.Connection = cnn
.CommandText = "CREATE TABLE IF NOT EXISTS [Security] ( [Id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[UserName] TEXT NULL, [Password] TEXT NULL, [DisplayName] TEXT NULL, [Level] TEXT NULL )"
.CommandType = CommandType.Text
End With
Try
cnn.Open()
Comm.ExecuteNonQuery()
cnn.Close()
Catch
End Try
End Using
End Using
But, in VS2013, it chokes on:
.CommandText = "CREATE TABLE IF NOT EXISTS [Security] ( [Id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[UserName] TEXT NULL, [Password] TEXT NULL, [DisplayName] TEXT NULL, [Level] TEXT NULL )"
since the line is split. I tried to remember to fix those, but obviously forgot a few. So, either run VS2017, or strip out all of the stuff giving you errors.