03-02-2006, 07:05 AM
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?
03-02-2006, 07:28 AM
why do u want to do this?
03-02-2006, 07:58 AM
so that when a user enter a new class, it will automatic create a table in db with that name.. and i will need that table to insert some data
03-02-2006, 08:15 AM
i mean, why do u want to do this, what will th end result be, how are u going to use it in ur asp pages?
03-02-2006, 10:07 AM
in the end i just want to create a table with that name only..
aniway, i solved it.. thanx aniway!
03-03-2006, 01:02 AM
ya, wanna ask u something.. can we change the name of the table using sal statement? i know we can change the name of column..
03-03-2006, 05:44 AM
I think you have to drop the table and re-create it with the new name.
I seriously think your db-design is wrong. A user entering a new class, is data, not structure. So if this event happens, it should be entered as data. Not by creating a new table.
03-03-2006, 07:43 AM
ya, but because my application works in this way, as i want to create a new table automatically..