Use TableDefs instead of Recordset. Here is an example:
Dim tdf as TableDef, fld as Field
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("FieldName",fieldsize) - the field size is going to be something like dbDouble, dbDate, dbText, etc.)
With tdf.Fields...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.