Continually Improving.... let us know how support@devdiamond.net Sign in | Sign up
home articles news blog forum  

 
 


 
Skip Navigation LinksHome > Article > Database Basics :: How to Secure you Access database
Database Basics :: How to Secure you Access database
Abstract :
Make your Access database more secure, dont allow people to download it and open it!

Views : 8095
Published : Monday, January 21, 2002
By
HyperLink

Avarage Rating :
Page Page 1 of 1


    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.

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\DatabasePath\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!



About Author

        Yasir Send Feedback
        Yasir is a .NET expert, with over 5 years experience in Microsoft Technologies, 8 years overall programming experience, he is the owner, founder & primary contributor of Minwar.com, and he also works as IT Director in the hospitality industry.