Access 97 help is very good on this, with examples that work. Search for the
CreateTableDef Method or for doing it in SQL (my preference) the Create
Table statement.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access