When using the update button on the mod_dbsetup.asp page I get this error: 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.
what does your connString from config.asp look like? Are you using the access 97 one? If so just used the access 2000 connection string and see if that works.
The problem was the database names in the choices in the config.asp are named different. (i.e. snitz_forums_2000.mdb and snitz_forum.mdb) I didn't notice this till I had been having problems for over 2 hours. This will make to hard for users that don't have much experience, to know to change the db name.
Topic Locked
Posted - 09 April 2001 : 15:03:30
