Adding Tables to a database

Is it possible to add tables to a MSAccess Database using ADO in ASP? That means in an ASP script. Is it?

thanks, ben.

Actually you'll need to use SQL to create your TABLE.

Look into CREATE TABLE....syntax

something like:

strSql = "CREATE TABLE..."

objConn.Execute strSql ....


Hope this helps!
Sincerely

Vlince

Thanks.

But I stil have a problem, I learned the syntax of the CREATE TABLE statment but I don't know how to defiene a Autonumber Feild, The syntax is like this:

sql = "CREATE TABLE tblname(Feildname FEILDTYPE, Feildname FEILDTYPE...)"
conn.Execute sql

now if I write TEXT in the feildtype it works, but if I type AUTONUMBER in the feildtype an error is executed that says:

"
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.

/tests/DBR/ct.asp, line 11
"

Is their a way to set a feild to AUTONUMBER?

I found this example googling on the web and look what I've found


CREATE TABLE tblContacts2 (
ID COUNTER,
LastName CHAR(40),
FirstName CHAR(40),
HomePhone CHAR(40),
WorkPhone CHAR(40),
Fax CHAR(40),
Email CHAR(40),
Address1 CHAR(40),
Address2 CHAR(40),
City CHAR(30),
State CHAR(10),
ZipCode CHAR(20),
CONSTRAINT ID_PK PRIMARY KEY(ID)
)

That is just an example

Hope this helps!
Sincerely

Vlince

Starts the unique values at 1 and increments by 1.

Tanks guy it worked!

I wrote the ID as Counter TYPE and it is an AUTONUMBER Type by MS Access, so thanks....