Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - MS Access 97 versus Access 2000
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MS Access 97 versus Access 2000

 Post Reply Post Reply
Author
SPooky View Drop Down
Newbie
Newbie
Avatar

Joined: 26 November 2003
Location: United States
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote SPooky Quote  Post ReplyReply Direct Link To This Post Topic: MS Access 97 versus Access 2000
    Posted: 26 November 2003 at 10:27am

I've setup the Web Wiz Forum on a 'PAID' Brinkster account and it works just fine despite the warning that it won't. However I only have MS Access 97 on my PC and can't read in the wwForum.mdb database file to be able to change the admin password at the tblAuthor record 1. Do I have to go out and buy MSAccess 2000 just to change my admin password??? There must be another way to setup an admin account. Brinkster supports MSAccess 2000 so that's not a problem. They just don't supply a database editor.

Maybe some ASP programmer out there can submit a snippet code that will read and write to those database records? I would do it but I don't now the Web Wiz mdb file's dataset structure. And I'm not all that ADOB connection oriented either. 

Spook

Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post Posted: 26 November 2003 at 10:33am

Here is a free WWW based database admin tool.  Its very good adn easy to use.  Allows you to edit database structure, content etc

 

http://home.infobahn.co.nz/download/asp/database/dbadmin23.z ip

Back to Top
thekiwi View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 23 November 2003
Location: New Zealand
Status: Offline
Points: 392
Post Options Post Options   Thanks (0) Thanks(0)   Quote thekiwi Quote  Post ReplyReply Direct Link To This Post Posted: 26 November 2003 at 10:37am
Originally posted by SPooky SPooky wrote:

Access 97 on my PC and can't read in the wwForum.mdb database file to be able to change the admin password at the tblAuthor record 1. Do I have to go out and buy MSAccess 2000 just to change my admin password??? There must be

Im probably missing something here ... but why dont you just login to the Admin account within your WWW Forum site ... and change its password, ie as an account holder would?

Back to Top
huwnet View Drop Down
Senior Member
Senior Member


Joined: 30 May 2003
Location: England
Status: Offline
Points: 1375
Post Options Post Options   Thanks (0) Thanks(0)   Quote huwnet Quote  Post ReplyReply Direct Link To This Post Posted: 26 November 2003 at 12:10pm
Yeah I was wondering that!!!
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post Posted: 26 November 2003 at 12:45pm

the forum is a database editor.. you can edit everything in the database with the forum.. you dont need access or another editor at all, and if you change the passwords manually in the database with access, then you have f**ked up the whole username..

passwords are encrypted and shows up like this in the database: 6734DDD7A6A6C9F4D34945B0C9CF9677F3221EC9



Edited by AnthraX
Back to Top
SPooky View Drop Down
Newbie
Newbie
Avatar

Joined: 26 November 2003
Location: United States
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote SPooky Quote  Post ReplyReply Direct Link To This Post Posted: 27 November 2003 at 10:19am

Here's the situation:

1) I just loaded WWF for the first time...

2) You can not log into the Admin account as there is none yet unless the programmer made a default one but he did not share the default password...

3) The programmer's very instructions in his remarked lines in common.asp is to manually edit the admin password even though he goes onto say that passwords are also encrypted. I just assumed that he meant it will encrypt my manual entry after I save it. (see footnote ¹)

I like your suggestion on a database editor kiwi I will try that. I don't think I will f^^^ it up as I'm just following the programmer's instructions. And I am not a novice ASP programmer either. What do you say Mr. Programmer. Help me before I do screw things up like anthrax says...

Spook

¹ - Footnote on common.asp

'Encrypted passwords
'This will make your forum unsecure from hackers if you disable this!!!!!
'This can NOT be changed once your forum is in use!!!
'You will also need to directly edit the database to type in the admin password to the Password field in the tblAuthor table at record position 1
'also edit both common.asp files to change this variable
Const blnEncryptedPasswords = true



Edited by SPooky
Back to Top
Semikolon View Drop Down
Senior Member
Senior Member


Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
Post Options Post Options   Thanks (0) Thanks(0)   Quote Semikolon Quote  Post ReplyReply Direct Link To This Post Posted: 27 November 2003 at 12:07pm

if you have read the readme file for webwiz forums you should know that the default admin username is Administrator and the default password is letmein..

it is an asp script that encrypts the passwords, not access, so if you manually change the admin password in the database without setting blnEncryptedPasswords to false then you have crashed the whole damn thing and have to reinstall..

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 27 November 2003 at 12:11pm
If you read the install insructions that come in the forums documentation folder you will find that a default admin account is created for you and what the username and password is for this account.

The comments that you refer to are for the constent for encrpyted passwords:-

Const blnEncryptedPasswords = true

As it says in the comments above this, if you disable the encrypted passwords your forum will be insecure and insructions on what to do if you do go ahead and disable the encrypted passwords.

This has NOTHING to do with installing the forum and 99.9% of users will never need or want to disable the encrytpted passwords.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.