Regarding to the post of <a href="http://forum.snitz.com/forum/pop_profile.asp?mode=display&id=2034">gmcm</a>. There stated an error:
Creating table(s)...
CREATE TABLE FORUM_FAQ( F_ID int COUNTER NOT NULL , F_FAQ_QUESTION VARCHAR (100) NOT NULL , F_FAQ_ANSWER memo NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
I've a solution for it. You have to delete the "int" and "NOT NULL", and add "PRIMARY KEY" for the field F_ID.
i.e.
CREATE TABLE FORUM_FAQ( F_ID COUNTER PRIMARY KEY , F_FAQ_QUESTION VARCHAR (100) NOT NULL , F_FAQ_ANSWER memo NOT NULL )
Topic Locked
Posted - 26 April 2001 : 04:06:15
