create table

[jl39775]

I am trying to create a table in vba docmd.execute("create testing (test1 char(2))"). It seems the the create statement doesn't work in access 2002. I've used it with oracle. I need a statement that will do this. Please help.

James

 

[jl39775]

I found my problem table was missing
this is how you do it.
("create table testing (test1 text(2))").

this is how not to do it.
("create testing (test1 char(2))").

James