G Guest Jul 2, 2006 #1 I'm trying to programatically remove a field from a table. Does anyone know a quick solution? Thanks.
I'm trying to programatically remove a field from a table. Does anyone know a quick solution? Thanks.
A Allen Browne Jul 2, 2006 #2 DROP the field: Dim strSql As String strSql = "ALTER TABLE [MyTable] DROP COLUMN [MyField];" DBEngine(0)(0).Execute strSql, dbFailOnError
DROP the field: Dim strSql As String strSql = "ALTER TABLE [MyTable] DROP COLUMN [MyField];" DBEngine(0)(0).Execute strSql, dbFailOnError