Make table SQL code?

[SirPoonga]

What is the code to create a table using SQL in Access?

In VBA I want to make a table and define field properties.

 

[[MVP] S.Clark]

You can use DDL - Data Definition Language or the Create method for Tabledef
object.

See the help file example in the Tabledef object help page thingy.

mkMSITStore:C:\Program%20Files\Common%20Files\Microsoft%20Shared\OFFICE11\1033\dao360.chm::/damthcreatetabledefx.htm

 

[Andi Mayer..]

What is the code to create a table using SQL in Access?

In VBA I want to make a table and define field properties.

CREATE TABLE MyTable (myField1 Text)

more in the help (Microsoft Jet SQL Reference)