Password Protect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

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

Regards

Hassan
 
Hi All,

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

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
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Hassan said:
Hi All,

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

Regards

Hassan
Click to expand...

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.
 
Baz said:
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.
Click to expand...

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.
 
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 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!
 
Baz said:
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".
Click to expand...

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