使用asp 创建access表问题

sql="create table T_OperationNote(id int IDENTITY (1, 1) PRIMARY KEY NOT NULL,content nvarchar (500) NULL)"

使用asp 创建表
语法错误 是 哪里出错啊各位 ？

---

SQL code:
sql="create table T_OperationNote ( [id] [int] IDENTITY (1,1) PRIMARY KEY NOT NULL,content nvarchar(500) NULL)"


试试这样

---

Dim sql
sql="create table test1(id int IDENTITY (1, 1) PRIMARY KEY NOT NULL,content nvarchar (255) NULL)"
Con.Execute sql

---

引用

Dim sql
sql="create table test1(id int IDENTITY (1, 1) PRIMARY KEY NOT NULL,content nvarchar (255) NULL)"
Con.Execute sql

提示 有语法错误

---

VB code:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("mydb.mdb"))
'conn.Open "DSN=Survey"

Dim strSQL
' Creates a table called survey3
strSQL = "CREATE TABLE survey3 (Q1 text(20),Q2 text(20));"

conn.Execute strSQL
%>

---

我想加一个 自增的 id 字段

---

http://www.china56zx.com

---

ID Counter

---

哦 忘了结贴了 问题已解决