CREATE TABLE IN ACCESS

[Rob]

Hi all,

Quick question, how do you create a table in MS Access from with an asp
script?

I will be creating the table name from Request.querystring("name"), also
needs fields of branchname and branchcode

guess something like CREATE TABLE & Request.querystring("name") branchname.
branchcode.

Thanks in advance
Rob

[Curt_C [MVP]]

I'm not certain but I belive the CREATE TABLE will work with access.....
Check the tSQL help files on this...

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"Rob" <hd***********@btopenworld.com> wrote in message
news:be**********@sparta.btinternet.com...

Hi all,

Quick question, how do you create a table in MS Access from with an asp
script?

I will be creating the table name from Request.querystring("name"), also
needs fields of branchname and branchcode

guess something like CREATE TABLE & Request.querystring("name") branchname. branchcode.

Thanks in advance
Rob

[Ray at]

Not sure what kind of columns BranchName and BranchCode need to be. I'll
assume Text(255) and Integer, respectively.

sTablename = Request.Querystring("name")

sSQL = "CREATE TABLE [" & sTablename & "] (BranchCode Int PRIMARY KEY,
BranchName Text(255));"

objADO.Execute sSQL
Ray at home

"Rob" <hd***********@btopenworld.com> wrote in message
news:be**********@sparta.btinternet.com...

Hi all,

Quick question, how do you create a table in MS Access from with an asp
script?

I will be creating the table name from Request.querystring("name"), also
needs fields of branchname and branchcode

guess something like CREATE TABLE & Request.querystring("name") branchname. branchcode.

Thanks in advance
Rob