|
EarlQuack
Starting Member
Netherlands
10 Posts |
 Posted - 08 June 2001 : 04:00:01
|
Hi,
Having the following error when I try to create the table required for the Eventes MOD.
CREATE TABLE FORUM_EVENTS( EVENT_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , DATE_ADDED#varchar (20)## NOT NULL , START_DATE#varchar (20)## NOT NULL , END_DATE#varchar (20)## NOT NULL , EVENT_TITLE#varchar (100)## NOT NULL , EVENT_DETAILS#memo## NOT NULL , ADDED_BY#int## NOT NULL , PRIVATE#int##0 NOT NULL )
-2147217900 | Syntaxisfout in velddefinitie.
Translation for 2147217900: Syntax error in field definition. (I use dutch Internet Explorer & OS)
I am using an Access 97 database with Access 2000 connectstring. (Tried the 97 connectstring, not working either) This error occurs when I try to update the database with HuwR's mod_dbsetup.
Does anyone know what the problem is?
Thx in advance,
EQ
Edited by - earlquack on 08 June 2001 04:01:46 |
|
Topic Locked
