By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

How to protect *.mdb with a password?

P: 5
Hi Friends,

I am new to Access.
I want to know if it is possible to protect the *.mdb file with a password?

If a user try to open, it should prompt for the password.

Regards,
Suresh
Dec 4 '06 #1
Share this Question
Share on Google+
4 Replies


markmcgookin
Expert 100+
P: 648
Hi there,

Setting an Access .mdb password is very simple, open your .mdb then go to Tools > Security > Set database Password

Mark
Dec 4 '06 #2

100+
P: 143
You should be aware that this is not very secure as there are a number of password crackers around.Perhaps you should think about full Access security?
Dec 4 '06 #3

missinglinq
Expert 2.5K+
P: 3,532
As with most security matters, the first thing to consider is what are you protecting from whom? You don't need a Chubb lock to secure the dustbin! Are you a manager of a janitorial company and you don't want just anyone wandering thru db where you have everyone's salary information? Or are you wanting to secure a db where multi-million dollar formulas are stored? It makes a big difference. And before considering "full Access security" be warned of what has always seemed to me to be a rather strange feature of Access; once you apply "Access" security to one db, it applies to all your Access dbs!
Dec 4 '06 #4

P: 5
hi all,

for beginners like me, this tip was very useful.
my usage is just to block some intruders who accidently try to open and change the data.

regds,
suresh
Dec 5 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.