472,127 Members | 1,871 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

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.

Dec 4 '06 #1
4 10820
648 Expert 512MB
Hi there,

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

Dec 4 '06 #2
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
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.

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.