469,351 Members | 1,769 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,351 developers. It's quick & easy.

How to protect *.mdb with a password?

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
4 10677
markmcgookin
648 Expert 512MB
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
Tanis
143 100+
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
3,532 Expert 2GB
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
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.

Similar topics

3 posts views Thread by Narlen | last post: by
1 post views Thread by Giganews | last post: by
5 posts views Thread by Brent Burkart | last post: by
12 posts views Thread by =?Utf-8?B?am9uaWdy?= | last post: by
22 posts views Thread by teejayem | last post: by
1 post views Thread by aRTx | last post: by
reply views Thread by CHAR72 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.