Yeah I know I'm an idiot, my forum works ok but I have forgotton my admin password...doh! Is there a way I can retrieve it? I have tried going into the database (password encryted) tried typing a new password in but it doesn't work, Surely I dont have to create a new database?
Make a new user account, download the db, change the m_level of the new user to 3 (admin). Get the member_id and change the config.asp "Const intAdminMemberID = 1" to the new member_id.
Upload the db and config.asp back and login with new account...now you are the admin and can change the password of the old admin account.
After that, change the config.asp back to the old member_id and delete the new 'temp' admin account.