Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Event Setup Error in Access DB
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MikeA
Starting Member

18 Posts

Posted - 15 June 2001 :  12:50:22  Show Profile
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  Show Profile
Nevermind, After I converted the database to Access 2000, then it worked.

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 15 June 2001 :  18:26:22  Show Profile  Visit HuwR's Homepage
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.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07