28/01/2013

How to make the MS-Access database password protected?


Freelance programmer like me always use MS-Access database while creating database software. Why we use MS-Access because it is easily and freely available with all the computers which are having MS-Word software because MS-Access comes free with MS-Word software package. So if you are using MS-Access as you database then it is very important to make you database password protected otherwise anyone can see or modify you data. For data security point of view all the database must be secured.


Now question is how to make the MS-Access database password protected. MS-Access gives very easy steps to make the database password protected and those steps are.
·         Open you database.
·         Click on Database Tool
·         Then click on set database password.
·         Save your password.
·         Close your database and open again this time your database will ask you to provide password.
Once you have made your database password protected then you have to mentioned mention password in your connection string.
Provider=Microsoft.Ace.OLEDB.12.0;Data Source= c;\myfolder\myAccess2007file.accdb; jet OLEDB: Database Password= here your password should be.


Happy coding.