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
 Access Database questions...		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

garrigus
New Member

53 Posts
Posted - 28 January 2008 :  09:21:28  Show Profile  Visit garrigus's Homepage
Is is possible to change the name and location of the forum database easily? If so, what would I need to do other than renaming the database file and changing its location?

Also, is it possible to add a password to the database and still have the forum code access it?

Thanks!
Scott

Podge
Support Moderator

Ireland
3775 Posts
Posted - 28 January 2008 :  09:25:50  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
You just have to change the path to the new database name in config.asp

You can find some examples of connection strings for password protected Access Databases here - http://www.sqlstrings.com/MS-Access-connection-strings.htm
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

garrigus
New Member

53 Posts
Posted - 28 January 2008 :  09:37:10  Show Profile  Visit garrigus's Homepage
Hi Podge,

Do I need to reinitialize the database after I change config.asp? And if so, how?

Thanks! I appreciate your help...
Scott
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 28 January 2008 :  09:40:52  Show Profile  Send ruirib a Yahoo! Message
No need to do anything, at all.

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

Podge
Support Moderator

Ireland
3775 Posts
Posted - 28 January 2008 :  09:57:51  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
If you are moving your forum database, put it in a folder which is not web accessible.

There is more info in the readme in Rui's sig, particularly the bit about setting the connection string.
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

garrigus
New Member

53 Posts
Posted - 28 January 2008 :  10:27:34  Show Profile  Visit garrigus's Homepage
By folder that is not web accessible, you mean where the directory can't be accessed via a browser, right?

But if someone knows the name of the file, they can still download it.

Thanks!
Scott
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 28 January 2008 :  10:33:05  Show Profile  Send ruirib a Yahoo! Message
If the folder is not web accessible, it can only be downloaded through FTP. To have a folder like this, you need to create it at the same level or above the level of your root web folder.

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

Podge
Support Moderator

Ireland
3775 Posts
Posted - 28 January 2008 :  10:59:33  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Most hosts nowadays will provide a non-web accessible folder for databases by default which already has read/write permissions.
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

garrigus
New Member

53 Posts
Posted - 28 January 2008 :  12:36:20  Show Profile  Visit garrigus's Homepage
Ah ha! Okay, I'll have to put a question in to my host provider...

Thanks!
Scott
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts
Posted - 28 January 2008 :  13:36:01  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
You're welcome.
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

garrigus
New Member

53 Posts
Posted - 28 January 2008 :  17:06:20  Show Profile  Visit garrigus's Homepage
Hi Podge,

Here's some code I found on that connection string page you mentioned...

<%
'declare the variable that will hold the connection string
Dim ConnectionString
'define connection string, specify database driver and location of the database
ConnectionString="Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\your_database_name.mdb;" &_
"Exclusive=1; Uid=your_username; Pwd=;"
%>

What is the Exclusive variable for?

Thanks again!
Scott
Go to Top of Page

Podge
Support Moderator

Ireland
3775 Posts
Posted - 28 January 2008 :  17:54:48  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
You don't want to open it exclusively, its like single user mode. Only one visitor would be able to use it at a time. You don't really need to password protect the database either, not if its in a folder which cannot be accessed via the web. Unless you don't trust trust your hosting company the default connections in config.asp should be fine.
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

garrigus
New Member

53 Posts
Posted - 28 January 2008 :  18:48:27  Show Profile  Visit garrigus's Homepage
Okay, cool... thanks again, Podge. I appreciate all your help!

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