View Single Post
  #4 (permalink)  
Old March 11th, 2004, 12:41 PM
jmss66 jmss66 is offline
Friend of Wrox
Points: 1,035, Level: 12
Points: 1,035, Level: 12 Points: 1,035, Level: 12 Points: 1,035, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

I was able to look at some sample Create table codes. After adding this create table code I am getting this error code:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in CREATE TABLE statement.
/MainServer/Main.asp, line 371


below is my create table code. I am using Microsoft.Jet.OLEDB.4.0 ACCESS 2000. Please someone, I need help on this. Is it because Jet OLEDB 4.0 does not support this create table? If not then what should I do? Any suggestions? Thanks.

set rsTempTb = Server.CreateObject("ADODB.Recordset")
sqlString = "CREATE TABLE Names (FirstName TEXT (20), LastName TEXT (20), DateOfBirth DATETIME, CONSTRAINT MultiConstraint UNIQUE(FirstName, LastName, DateOfBirth) )"
rsCART.Open sqlString, objconn, adOpenKeyset,adLockOptimistic


Reply With Quote