I am trying to add columns to a table using information gathered from a form. I keep getting the error "The database engine could not lock table because it is already in use...."
What am I missing?
Private Sub Command0_Click()
Dim TableName As String
Dim ColumnName As String
Dim DataType As String
Dim AddColumn As String
TableName = "ALTER TABLE" & " " & Me.textBox1
ColumnName = "ADD COLUMN" & " " & Me.textBox2
DataType = Me.textBox3 & ";"
AddColumn = TableName & " " & ColumnName & " " & DataType