Password Protect

[Hassan]

Hi All,

How I can protect my database with password and is there any way to protect
the form?

Regards

Hassan

 

[Scott McDaniel]

Hi All,

How I can protect my database with password and is there any way to protect
the form?

Access has builtin password protection, however it's pretty weak (at least in pre-2007 versions). Click Tools - Security
- Set Database Password.

What do you mean by "protect the form"? You can deploy your database in the .mde format (2003 or older versions) and
users won't be able to view the Design of your Forms/Reports/Modules (they can still view Tables and Queries, however).

If you want to password protect a form, see this link:

http://support.microsoft.com/kb/209871

Regards

Hassan

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Rick Brandt]

The best way to protect the design of your database (if that's what you
mean) is to distribute it as an executable file. It's pretty easy to make
one of these, but exactly what you do depends on what version of Access and
what kind of Access file.

I believe you meant "an MDE file" which is not an executable. It is merely an
MDB with no design ability for code based objects.

 

[Baz]

The best way to protect the design of your database (if that's what you
mean) is to distribute it as an executable file. It's pretty easy to make
one of these, but exactly what you do depends on what version of Access and
what kind of Access file.

 

[Baz]

I deliberately avoided saying "mde" because it might be an ade (or an accde,
if there is such a thing?!?).

Obviously it isn't an executable program, which is why I said "executable
file".

Pedantic? Well that makes two of us!

 

[Rick Brandt]

I deliberately avoided saying "mde" because it might be an ade (or an accde,
if there is such a thing?!?).

Obviously it isn't an executable program, which is why I said "executable
file".

For the vast majority of people asking the question posed in the OP it would not
be obvious at all.