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
 Multiple Forums One Database?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

roa360
Starting Member

USA
12 Posts

Posted - 10 April 2009 :  11:10:18  Show Profile
Hi im setting up a website that will have multiple subdomains each using a different forum, but i want users to be able to share there same login info across each forum. In the snitz install page it said to chang the value strTablePrefix, but leave the strMemberTablePrefix value alone.

Problem is that inc_create_forum_access.asp dosen't create all of the proper tables to do a fresh install of the database. Ive searched the forums and I cant find anybody who has had this problem, which supprises me.

so if ANYONE CAN HELP PLEASE thanks.

Edited by - roa360 on 10 April 2009 11:11:23

AnonJr
Moderator

United States
5768 Posts

Posted - 10 April 2009 :  11:37:17  Show Profile  Visit AnonJr's Homepage
Just a thought, but have you searched for your question? There have been a number of people asking the same or similar, and the short answer is yes - you can run multiple forums that share login information. inc_create_forum_access.asp doesn't create any tables in Access because Access is NOT the type of database you are going to want to use for something like that. Get a real RDBMS like SQL Server or MySQL.

For detals, check the dozzen or so posts floating around here.
Go to Top of Page

roa360
Starting Member

USA
12 Posts

Posted - 10 April 2009 :  11:39:35  Show Profile
darn thats what i thought u would say

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 10 April 2009 :  17:17:55  Show Profile  Send ruirib a Yahoo! Message
You can import tables from one Access Db to another, so that could be a way to overcome the installation issue.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

KC
Junior Member

USA
152 Posts

Posted - 13 April 2009 :  14:00:55  Show Profile  Visit KC's Homepage
Personally I have been running several Snitz forum based sites for several years and glad they are not all in one database.
That would be a nightmare and so huge it would now be unmanageable.

All you need to do is make a page for "Join Another Site Here", let them choose a site, make sure they are on logged on, and then just copy their member data and insert it into the other sites database.

I have been meaning to do this on my sites for awhile but never got a...


Hehehe ;-}

Owner of vales.com and Elite Computers.
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 14 April 2009 :  01:16:47  Show Profile  Visit Etymon's Homepage
Hey! Nice Rount Tuit! Does it come with a necklace? I want to keep mine with me as a keepsake!
Go to Top of Page

KC
Junior Member

USA
152 Posts

Posted - 14 April 2009 :  14:22:32  Show Profile  Visit KC's Homepage
quote:
Originally posted by Etymon

Hey! Nice Rount Tuit! Does it come with a necklace? I want to keep mine with me as a keepsake!

Hehehe, beats me, I just googled Round Tuit and picked the first image I liked, but there were thousands ;-}


Owner of vales.com and Elite Computers.
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07