Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Help!!!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JNariss - 13 Dec 2005 17:58 GMT
Hello,

In my database I have created a form which I only want to allow certain
people to open up and fill out.

I thought that by creating a table called "Code" with a password in one
of the fields will give me the ability to somehow do this. But now I am
stuck.

So far..............I created a table and called it Code and added one
record to it with the word: snow.

I created a custom form dialog box which says: please enter the code
below

I want the user to enter the word "snow" and once they click the ok
button the form will appear. However if the word "snow" is not entered
or another word is entered I want a message box to appear saying "You
must enter the correct code"

Is there a way to do this and how?

Thanks,
Justine
Rick B - 13 Dec 2005 18:03 GMT
Access includes a built-in User-Level Security system to allow you to create
userid and passwords then to assign specific privileges to every object in
your database.

Don't reinvent the wheel, use the tools available.  Using your home-grown
security has tons of holes.  What keeps the user from simply opening the
table and bypassing your form altogether?  What prevents them from going
into design view and reading your code?

Read and reread the following links, make a backup copy of your files, then
follow every step in order.

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

Signature

Rick B

> Hello,
>
[quoted text clipped - 20 lines]
> Thanks,
> Justine
JNariss - 13 Dec 2005 18:18 GMT
Rick-

I really appreciate your quick response. However, here is the problem:
I don't have the time to set up security right now. My boss's boss
needs this done today by 3 and I don't really have the time to set up
each users security. So that is why we came up with the code dialog
box. I will eventually set up security but right now we just need it on
this one form.

Thanks,
Justine
Rick B - 13 Dec 2005 18:23 GMT
If it is temporary and you know it will not be very secure, then just get
rid of the table and do it all in code.

Set the form or file to locked.

Ask the user to enter the password.

If the password equals snow, unlock the form.

Otherwise, loop.

Signature

Rick B

> Rick-
>
[quoted text clipped - 7 lines]
> Thanks,
> Justine
Rick B - 13 Dec 2005 18:29 GMT
Or just build TWO userIDs for the moment.  One that has access to the form,
and one that does not.

Then, later go back and add the rest of your users.

Signature

Rick B

> Rick-
>
[quoted text clipped - 7 lines]
> Thanks,
> Justine
JNariss - 13 Dec 2005 19:44 GMT
Thanks Rick,

I will try to do the lock form method. I really appreciate all your
help.

Justine
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.