Table creation

  • Thread starter Thread starter The Iconoclast
  • Start date Start date
T

The Iconoclast

Greetings.
Can anyone please help me?
Is it possible to create a table with several fields by means of code? Also
is it possible to delete a table by means of code (VBA).

Thanks.
 
Yes to both. Recognize, of course, that VBA and Macros are not the same
thing in Access.

I use DAO for things like this. You'll need to use the CreateTableDef and
CreateField methods for the first. You'd use the Delete method of the
TableDef collection for the second.
 
Back
Top