| Author |
 Topic  |
|
Doughnut
Starting Member
United Kingdom
40 Posts |
 Posted - 06 December 2001 : 12:46:09
|
good to see your up and running!
Av Fun 
...............................................
Snitz 3.3.03, hosted by 121, access 2000 database.
Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2.
Forum: www.carp-uk.net/forum |
 |
|
|
RCHAWAII
Junior Member
USA
277 Posts |
Posted - 08 December 2001 : 15:29:41
|
[quote]
Hi Ransom,
Just a little update here!
Use this line instaed of the line I gave you:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/your_username_goes_here/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
Hello, Now I am confused. I am on brinkster and have no idea which one I should use now...
my brinkster name is rchawaii I guess you know the rest..
One less thing: All this talk about people downloading the config. File abd database, is this because of brinkster? And if So, is there a way besides renameing a file? That sounds like an awfully problematic solution. What if somebody d/l your db or config file/s then uploads it again??? It there a way to change attributes of the files on brinkster - like HIDDEN ....thanks
Edited by - rchawaii on 08 December 2001 15:33:23 |
|
|
|
Doughnut
Starting Member
United Kingdom
40 Posts |
Posted - 09 December 2001 : 07:41:57
|
Hi,
use this one:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPat("/your_username_goes_here/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
I think you can also password your database; here are some instructions from Brinkster, I've not tried these myself so take care & make sure you backup your database first...
Secure Your Access Database
How can you keep unwanted people from downloading your database simply by typing in the url? You can't, it is not possible. BUT you can secure it by adding a password to it. Below I will walk you through the steps needed to accomplish this.
1. Download your database (new feature added today, see above).
2. Open it up in MS Access. (Check the "Exclusive" checkbox in the file dialog box. If you don't, Access will ask you to later.)
3. Menu Bar --> Tools --> Security --> Set Database Password Select "Tools" from the menu bar, then "Security", then "Set Database Password."
4. Your password can be: (quoted from MS Access Help) "Passwords can be any combination of 14 or fewer characters, except control characters. Passwords are case-sensitive."
5. Upload your password protected database to Brinkster.
6. What needs to be changed in your code:
Only your connection string needs to be changed. Here is a sample:
Set Conn = Server.CreateObject("ADODB.Connection")
MyConnStr = "DRIVER={Microsoft Access Driver (*.mdb)}; "
MyConnStr = MyConnStr & "DBQ=d:\sites\membername\db\mydbase.mdb; "
MyConnStr = MyConnStr & "PWD=yourpassword"
Conn.Open(MyConnStr)
Add the "PWD=yourpassword" to the connection string and you are set!
7. In the SQL Mgr, a new field has been added for password. This way you can still use the SQL Mgr, even if your Access database has been password protected!
By: Jared Stauffer
Good Luck, Robin.
...............................................
Snitz 3.3.03, hosted by 121, access 2000 database.
Mods Installed: Active Users, PM, IP Ban, Hide email. Avatar2.
Forum: www.carp-uk.net/forum |
|
|
|
Topic |
|
|
|
Topic Locked
