Encrypt your Access database

Secure Your Access Database

How can you keep unwanted people from downloading your database simply by typing in the URL?

You can ' t, it's not possible. BUT can secure it by adding a password to it. Below I'll

Walk you through the steps needed to accomplish this.

1. Download your database (new feature added today, above).

2. Open it up in MS Access. Check the "Exclusive" checkbox in the File dialog box. If you don ' t,

Access would 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: (quoted from MS Access help) "Passwords can is any combination or

Fewer characters, except control characters. Passwords are case-sensitive. "

5. Upload your password protected database to Brinkster.

6. What needs to is 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 your are set!

7. In the SQL Mgr, a new field has been added for password. This way your can still use the SQL

MGR, even if your Access database has been password protected!

By:jared Stauffer