form security

[Guest]

Is there a way to restrict access to a form? I have one form I need to
secure - it's the only thing in the whole database that I need to restrict
access to. Is there a way to do this without setting up logins and security
for all of the other users? Any suggestions?

Thanks!

 

[Rick B]

It is the only thing in the whole database you need to restrict? What about
the query upon which the form is built? What about the actual table where
the data is stored?

To restrict a user from a form, I assume you want to make sure they can't
see, delete, or change the data in that form. You would also have to
restrict them from changing, deleting, or seeing the queries and tables (and
even reports that might be based on the same).

I would expect that you would need to step back and think about what all
needs to be secured, then properly implement User-Level Security and give
the appropriate permissions based on your needs.

Hope that gets you thinking on your needs. For more data on how to
implement the security, see the following links...

Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

 

[Guest]

Rick - The user cannot "access" the tables or the queries on which my forms
are based - I have it set up where they cannot get to the database itself.
They just have access to the form. I have thought about this and it is why I
asked the question. Please don't assume I have not thought about this prior
to posting - I have.

I simply asked if there was a way to restrict access to a particular form -
sort of like a password to open an object. If there isn't, that's fine.
Please do not pass your judgement on my thought process prior to posting or
whether I have done a search for a post prior to asking a question.

 

[Rick B]

No need to get in a wad there Lori. I was simply pointing out that securing
only a form does no good. You did not mention in your post that they were
already locked out of the tables. The reason I mention searching is that it
is the polite way to use a newsgroup. You don't really want helpful folks
to have to post an answer that is already out there do you?

If you have already secured them out of the tables and queries, then just do
the same for the form. Remove their access to that form.

There are ways to add passwords, but if you have already secured the
database, then there is really no need to do that. Also, any kind of "pop
up password" scheme is often very easy to get around.

There are previous posts out there on how to "password protect a form"
though if you still want to go down that path.

 

[Rick B]

Here are some links that will tell you how to password protect the form if
you still want to go that route...

http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

 

[Rick Brandt]

Rick - The user cannot "access" the tables or the queries on which my forms
are based - I have it set up where they cannot get to the database itself.
They just have access to the form. I have thought about this and it is why I
asked the question. Please don't assume I have not thought about this prior
to posting - I have.

If you have not set up full blown user level security then users CAN get to the
table. You might have set up some obfuscation to prevent the average "clerk"
from getting to it, but anyone who has even a casual familiarity with Access can
get to it if security is not in place.

I simply asked if there was a way to restrict access to a particular form -
sort of like a password to open an object. If there isn't, that's fine.
Please do not pass your judgement on my thought process prior to posting or
whether I have done a search for a post prior to asking a question.

Yes there are ways to restrict the ability to open a form IF you provide users
with an MDE. In that case even an advanced user would not be able to open the
*form*. All you need to do is prompt for a password in the Open event and set
the Cancel argument of that event to True when the password is incorrect.
Getting to the tables though would be trivial.

An Access form cannot exist in isolation from its Data Source. If the table or
query is in the same MDB file as the form then it can be gotten to. This would
be very easy without User Level Security and only a bit harder with ULS.

 

[TC]

Any user with a basic knowledge of Access can create a new database &
link directly to the tables in yours. Then they can view, add, edit and
delete records to & from your tables, without any restrictions at all.

HTH,
TC (MVP Access)
http://tc2.atspace.com