Creating Table query through Windows Form Application

[Z33shan]

hello :)

i'm using MS access as a database of my Windows form application.
i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand.
suppose,

string city = "newyork";

and city should be the name of table in example.

Thanks :)

[ChrisPadgham]

please post the sql that is not working

[Z33shan]

heres the query that i have used:

"create table '" + new_city + "' (ID AUTONUMBER, population TEXT, area TEXT)";

try to mention adding primary key constraint aswell.

thanks :)

[aquilax]

Check this article on Access DDL:

http://www.databasejournal.com/features/msaccess/article.php/3460771/Access-Data-Definition-Language-DDL-Creating-and-Altering-Tables-On-The-Fly.htm