Добавление поля в таблицу (ADOX)По материалам: https://www.everythingaccess.com/tutorials.asp?ID=ADOX-programming-examples#ShowAllTables Function ModifyTableAdox() 'Purpose: Show how to add fields to a table, and delete them using ADOX. Dim cat As New ADOX.Catalog Dim tbl As ADOX.Table Dim col As New ADOX.Column 'Initialize cat.ActiveConnection = CurrentProject.Connection Set tbl = cat.Tables("tblAdoxContractor") 'Add a new column With col .Name = "MyDecimal" .Type = adNumeric 'Decimal type. .Precision = 28 '28 digits. .NumericScale = 8 '8 decimal places. End With tbl.Columns.Append col Set col = Nothing Debug.Print "Column added." 'Delete a column. tbl.Columns.Delete "MyDecimal" Debug.Print "Column deleted." 'Clean up Set col = Nothing Set tbl = Nothing Set cat = Nothing End Function |
|||
L.E. 27.06.2022 |