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
 Help please: mod_dbsetup syntx error
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

TheMarkel
Starting Member

USA
14 Posts

Posted - 21 April 2001 :  13:45:15  Show Profile  Visit TheMarkel's Homepage  Send TheMarkel an AOL message  Send TheMarkel an ICQ Message
I *always* get this error when attempting to set up any kind of dbase tables in my Access dbase using the MOD setup script:

quote:
Creating table(s)...
CREATE TABLE FORUM_ONLINE( UserID;varchar (100);; NOT NULL , UserIP;varchar (40);NULL; NOT NULL , DateCreated;varchar (100);; NOT NULL , LastDateChecked;varchar (100);; NOT NULL , CheckedIn;varchar (100);; NOT NULL , LastChecked;varchar (100);NULL; NOT NULL , M_BROWSE;text;NULL; NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.


I am using an Access 2000 dbase over a DSN connection. The only way I get Avatar setup to work correctly is to hand-edit the table, but I would like to know if there's something I'm doing wrong here.

'move every 'sig.''


--markel

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 21 April 2001 :  13:49:39  Show Profile  Visit HuwR's Homepage
open up the dbs file and change all the ; into #

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.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07