How to protect *.mdb with a password?

[sureshpalani]

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

[markmcgookin]

Hi there,

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

Mark

[Tanis]

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?

[missinglinq]

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!

[sureshpalani]

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