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: General / Classic ASP versions(v3.4.XX)
 Database Protection
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

mickt
Starting Member

8 Posts

Posted - 24 August 2002 :  05:27:21  Show Profile
How can I protect the database from being downloaded i.e. someone just typing in the name of the database .mdb file and seeing all my members?

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 24 August 2002 :  05:31:27  Show Profile
The best thing to do is to put the database in a directory that is not accessible via the web. Anything on the same level as your webroot, or above it should work.

This is from the readme.htm file:

quote:
Change the database name:
When using an Access database, all the data is stored in a single file, unlike the other databases. So caution should be taken in where you store your Access database as it can be downloaded by anyone if they know the path. If you store your Access database in a folder outside of your www folder (or wherever you keep the files for the rest of your site), then you should be safe because no one can download your database if it is outside of your www folder. If you store your database in a cgi-bin folder, or in your www folder, then it is strongly recommended that you change the default database name from snitz_forums_2000.mdb to a cryptic or not easy to guess name. The name should be a combination of letters and numbers. That makes it hard for anyone to guess the name of your database.

Example: n92yr2fnis.mdb
Go to Top of Page

mickt
Starting Member

8 Posts

Posted - 24 August 2002 :  05:34:24  Show Profile
Thanks
Go to Top of Page

mickt
Starting Member

8 Posts

Posted - 24 August 2002 :  05:36:05  Show Profile
That's fine but which pages do I need to change the path to the database in?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 24 August 2002 :  05:36:25  Show Profile
config.asp
Go to Top of Page

mickt
Starting Member

8 Posts

Posted - 24 August 2002 :  05:38:27  Show Profile
Yeah just looked at that so it's just the
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
line would change to
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/new-database-name.mdb") '## MS Access 2000 using virtual path
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 24 August 2002 :  05:39:56  Show Profile
yes
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.41 seconds. Powered By: Snitz Forums 2000 Version 3.4.07