Password Protect

[Guest]

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

 

[Joseph Meehan]

Hi All,

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

Regards

Hassan

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

Access 2007 as it doesn't support user-level security.

Access also offers a simple password system with I believe two levels of
access, but it is very easy to defeat.

 

[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.