Hi all...

I have a question... i have been searching answer for this for quite a l0ng time...

I'm using asp and microsoft access..

I have a database name, "db1.mdb"

I want to create a new table inside this database after submittin a name in my form..

But how do i write my sql statement to execute this?

Thanx

As I understand you need the "create table" statement.
Look at http://www.w3schools.com/sql/sql_create.asp
for more
dimis

okay, thanx!

ya, wanna ask u something.. can we change the name of the table using sql statement? i know we can change the name of column..

I'd suggest checking around the link you have ( http://www.w3schools.com/sql ).

Otherwise not sure if perhaps could do this using ADOX:

How do I create a database from ASP?
http://www.aspfaq.com/show.asp?id=2029

ADOX API Reference
http://msdn.microsoft.com/library/de...ireference.asp