| Author |
 Topic  |
|
|
Syedur
New Member
USA
93 Posts |
 Posted - 01 June 2001 : 19:53:13
|
Hi guys,
Sorry for the trouble again,
How come everytime I try to make my database password protected, it won't run.
I tried putting the password by Access.
But everytime I do that... I get an error and the forum doesn't run.
Anyone knows any solution to this problem?
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 June 2001 : 20:04:34
|
yes I do have the solution for you...
you have to specify the password in the strConnString line.
example:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\database\snitz_forums_2000.mdb;Jet OLEDB:Database Password=password" '## MS Access 2000 |
 |
|
|
Syedur
New Member
USA
93 Posts |
Posted - 01 June 2001 : 21:50:30
|
Hey Rich,
Thanks for a quick reply.
I am not trying to be rude.
But if I announce the password in the config.asp file... then anyone can download that and then look at my password. Its one way or the other.
I was going to put password protection on the whole database directory.
But when I asked my host to do this for me, they eventually did it.
And then again, I got an error saying that database doesn't have the access to read/write.
So, is there anything specific I can tell my host to do and then the database will have read/write access? Or is there any way to encrypt the config.asp file?
Thanks
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 June 2001 : 21:56:41
|
| nobody can download your config.asp file. |
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 01 June 2001 : 21:59:24
|
Ok...
That explains it...!!!
Thanks a lot!!!
----------------------
But do you still have a solution for the database folder protection?
I mean why isn't it working?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 June 2001 : 22:00:48
|
| not sure why it's not working. Must be that the permissions aren't setup correctly by your host. I know that you can password protect the database directory and still use the database in that directory with the forum, just not exactly sure what needs to be set and how it needs to be set. |
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 01 June 2001 : 22:08:37
|
Ok...
Thanks a lot.
I will tell them to give it another shot anyway...
Later.
|
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 03 June 2001 : 01:06:07
|
Richard,
Is there any way to Password Protect an Access Database if you do not have Access installed on your Computer? I have searched around for free software which would enable me to not only password protect my Snitz Database, but also to edit, delete tables etc., but have had no luck (other than Table Edit, which does not give me the ability to do what I want {b}on my own computer{/b})
So, looking to the Experts for ideas..... 
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind  * |
|
|
|
Syedur
New Member
USA
93 Posts |
Posted - 03 June 2001 : 03:24:23
|
I think micromedia drumbeat is a database product.
I don't know any free one though!
Although, you can add the password yourself by coding.
There is a time in every man’s education when he arrivers at the conviction that envy is ignorance; that imitation is suicide. |
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 03 June 2001 : 22:16:38
|
Okay, but what coding would I use to Password Protect my Snitz .mdb?
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind * |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 03 June 2001 : 22:31:29
|
I think too much emphasis is placed on password protecting a database. IF someone was even able to find and download your database then I am sure they would also have a program like this:
http://www.pwdservice.com/
this program is EXTREMELY cheap and works 100%. here are some simple tips...
1. rename database
2. create entirely different directory for the database with NO DIRECTORY BROWSING
3. change forum Admin account password. I can't tell you how many forums I have come across where I try the default password and I get in no problem!!!!!
this is just basic stuff but it is a good start
Dayve |
|
|
| |
Topic |
|
Topic Locked
