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: Database: MS Access
 Database seems to be missing a table? Please Help
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bitmask
Starting Member

2 Posts

Posted - 28 February 2001 :  20:47:12  Show Profile
Microsoft JET Database Engine error '80040e37'

The Microsoft Jet database engine cannot find the input table or query 'FORUM_ARCHIVE_TOPICS'. Make sure it exists and that its name is spelled correctly.

/forum/default.asp, line 297


alamander
Starting Member

3 Posts

Posted - 28 February 2001 :  21:06:51  Show Profile
yes i have the same problem

Go to Top of Page

bitmask
Starting Member

2 Posts

Posted - 28 February 2001 :  21:44:39  Show Profile
Go to admin options
then click check installation
then click upgrade database
choose database to upgrade to
this worked for me

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 28 February 2001 :  21:46:39  Show Profile  Visit HuwR's Homepage
You have either tried to install the archive mod, or the latest alpha code.

either way, you have not made the DB update changes. look in either your tools or Mods directory, there should be a file called mod_dbsetup.asp, execute this in your browser, and select Admin Forums from the dropdown and hit proceed. This will add the new tables to the DB.

Go to Top of Page

alamander
Starting Member

3 Posts

Posted - 01 March 2001 :  08:09:48  Show Profile
Thanks!!

Go to Top of Page

modemmike
Starting Member

USA
20 Posts

Posted - 01 March 2001 :  21:22:33  Show Profile
I am also having this problem and I have tried everything here. Would anyone like a stap at it ?
http://www.toledonights.com/forums

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 01 March 2001 :  21:37:22  Show Profile  Visit HuwR's Homepage
Did you run the mod_dbsetup.asp file

Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 01 March 2001 :  21:39:06  Show Profile
It's fixed.

HuwR, he has the alpha version. Just ran the db setup file.

Edited by - Davio on 01 March 2001 21:41:04
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 01 March 2001 :  21:49:15  Show Profile  Visit HuwR's Homepage
ok, thanks Davio.

I found a small prob in the files for the Poll.
In the code added to Default.asp, it says

set rsPoll = my_Conn.Execute (strSql)

if not rsPoll.EOF or rsPoll.BOF then

it should be

set rsPoll = my_Conn.Execute (strSql)

if not (rsPoll.EOF or rsPoll.BOF) then



Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 01 March 2001 :  22:01:30  Show Profile
k, thanks HuwR.
Go to Top of Page

modemmike
Starting Member

USA
20 Posts

Posted - 02 March 2001 :  10:44:47  Show Profile
Thanks for the speedy response guys !
I need to setup all the colors now but other than that it works great !

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