Table creation

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.
 
D

Douglas J. Steele

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.
 
Top