Deleting Fields from BE table

[EddyLLC]

I use the following code to add field to a backend table. How can I delete a field from a backend table? Thanks


Set wrkDefault = DBEngine.Workspaces(0)
Set dbsUpdate = wrkDefault.OpenDatabase(DatabasePath, True)
Set tdfUpdate = dbsUpdate.TableDefs("tbl1")
With tdfUpdate
Set tdfField = .CreateField("Field1", DB_BOOLEAN)
.Fields.Append tdfField
End With

 

[CautionMP]

EddyLLC,
[tt]tdfUpdate.Fields.Delete "FieldName"[/tt]?

CMP

(GMT-07:00) Mountain Time (US & Canada)