Create Table method 1

[4321z]

Trying to use the create table example given in the access help files below

CREATE TABLE FirstTable(FirstName TEXT,LastName TEXT);

and i keep getting a compile error "Expected: End of Statement"

Is this not the method to use to be able to create a table on the fly?

 

[Kadanis]

From what you've typed it looks as though you are trying to use the SQL create table method. If thats the case you need to enclose the SQL in quotations as a text string and then use the Execute command to action the SQL.

Should look something like this

CurrentDB.Execute "CREATE TABLE FirstTable(FirstName TEXT,LastName TEXT);"

That should have the desired effect

Hope it helps.