• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• While App. is running adds a column to the specified table in the Database using SQL statements.

While App. is running adds a column to the specified table in the Database using SQL statements.

While App. is running adds a column to the specified table in the Database using SQL statements.

API Declarations


Dim *cmd* As ADODB.Command



Rate While App. is running adds a column to the specified table in the Database using SQL statements.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; & _ 'For Access 2000
Data Source = *Drive/FolderName/DatabaseFileName*   '* = type in your location
cnn.Open
    
Set cmd = New ADODB.Command
     With cmd
          .ActiveConnection = cnn
          .CommandType = adCmdText
          .CommandText = "ALTER TABLE tblSoftware ADD COLUMN " & _
               txtNewData.Text & " Char(30)"
          .Execute
     End With
    
     cnn.Close
     Set cnn = Nothing
     Set cmd = Nothing
'***********************************************************