Is it possible to dynaically create table name in MS Access:
Below is my CODE:
strSQL = "CREATE TABLE" + Me.Text + "( ID Counter," & _ "Name TEXT(50) NOT NULL," & _ "PRIMARY KEY(ID) )"
But,im getting a run time error that syntax is wrong.
Appreciate your help!