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
 Huwr - Problem creating table
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

toby
Starting Member

2 Posts

Posted - 24 June 2001 :  11:15:42  Show Profile
Hi
Even after converting the db to access 2000, I still keep getting the following messages.
Any ideas?
Thank you.
Toby

File Attachment Mod

Creating table(s)...
CREATE TABLE FORUM_USERFILES( F_FILEID int COUNTER NOT NULL , MEMBER_ID int NOT NULL , F_FILENAME text (255) NOT NULL , F_FILESIZE int NULL , F_REPLY_ID int NULL , F_TOPIC_ID int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in CREATE TABLE-Anweisung.

--------------------------------------------------------------------------------

Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWDOWNLOADS int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in ALTER TABLE-Anweisung.
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWUPLOADS int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in ALTER TABLE-Anweisung.
Table(s) updated

--------------------------------------------------------------------------------

Updating Forum Values..
DELETE FROM FORUM_MODS WHERE (M_NAME = 'Attachment' OR M_CODE = 'Attachment')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Das Microsoft Jet-Datenbankmodul findet die Eingangstabelle oder Abfrage 'FORUM_MODS' nicht. Stellen Sie sicher, dass sie existiert und der Name richtig eingegeben wurde.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faMaxSize','512')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faExtensions','.zip:.mdb:.txt:.asp')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','Attachment','1')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Ausgabetabelle 'FORUM_MODS' nicht gefunden.


HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 24 June 2001 :  12:31:01  Show Profile  Visit HuwR's Homepage
try changing your connection string to the Jet4 driver

Go to Top of Page

toby
Starting Member

2 Posts

Posted - 24 June 2001 :  16:43:07  Show Profile
Thanks a lot.
Now it's working as it should!
Great mod!

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