| Author |
 Topic  |
|
|
MikeA
Starting Member
18 Posts |
 Posted - 15 June 2001 : 12:50:22
|
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID int COUNTER NOT NULL , DATE_ADDED text (20) NOT NULL , START_DATE text (20) NOT NULL , END_DATE text (20) NOT NULL , EVENT_TITLE text (100) NOT NULL , EVENT_DETAILS memo NOT NULL , ADDED_BY int NOT NULL , PRIVATE int NOT NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
|
|
|
MikeA
Starting Member
18 Posts |
Posted - 15 June 2001 : 16:06:43
|
Nevermind, After I converted the database to Access 2000, then it worked.
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 June 2001 : 18:26:22
|
for your info, the access 97 (*.mdb) driver is the cause of the problem, rather than the version of the DB. the 97 driver does not like the DEFAULT directive.
|
|
|
| |
Topic |
|
|
|
Topic Locked
