|
gemma
Starting Member
6 Posts |
 Posted - 18 April 2001 : 10:44:05
|
When I run the mod_dbsetup.asp, click on Smile Manager from the drop down menu & click on Update, I get the following error message:
Creating table(s)...
CREATE TABLE FORUM_SMILES( S_ID int COUNTER NOT NULL , S_CODE VARCHAR (15) NOT NULL , S_URL VARCHAR (255) NOT NULL , S_DESC VARCHAR (255) NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Can some1 pls help?? 
thnx
Gemma
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 18 April 2001 : 11:22:44
|
There are two things you can do.
1) change your connection string in config.asp to use the access2000 driver and not the access 97.
If you are unable to do this, then open mod_dbsetup.asp, and search for
int COUNTER
and remove the 'int'
|
 |
|
Topic Locked
