Beginner Access Security question

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

Guest

I have written some programs in Access, but have never had a need to implement security. Now I have a client where all users in the office want to use an existing Access 2002 application to modify data, but they would like all users to be prevented from getting into the data directly through Access (they ALL have Access installed). I have done some reading about Access security, which appears to be complex. Before I start diving into Access security, could anyone please advise me, firstly, on if what I want is possible through Access. Secondly, could you provide infomation on the general procedure that I might follow to accomplish this, or perhaps a good book or link to where this infomation can be found. Any help in sending me down the correct path would be greatly appreciated. Kindest Regards.
 
Depends on how absolute the need is that they not access the tables.

Access security will accomplish what you want, however Access is a file
based database. That means that users must have access to the mdb in order
to use it (unlike a server database).

For average users that aren't keen to break into it, Access security is
fine. If someone is determined, they can break in.

If you are going to use Access security, you can deny permissions to the
tables, and use RWOP queries for all data interaction (RWOP means run with
owner permissions).

The security FAQ is
http://support.microsoft.com/?id=207793

It hasn't been updated since 2000, however there isn't much new. Running
the security wizard in 2002 will do the job. More info at
http://www.jmwild.com/security02.htm

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

Although the whitepaper is old, it contains information to help you
understand security.

Other good reads
Lynn Trapp's
http://www.ltcomputerdesigns.com/Security.htm

Jack MacDonald's
www.geocities.com/jacksonmacd
 
Thanks so very much for sending me down the right path. I will go through the links that you have provided and, with an ear for the approach that you have given, I will explore how to make this work. In my case the users we are concerned about are the network "teekers", rather than determined hackers, so it sounds likely that Access security will work. Thank again for your thoughtful and quick response! Regards.
 
You don't need security to complete hide the ms-access interface.

In fact, you don't even need any code to accomplish this.

You don't want to get confused between using security that prevents certain
users from running reports, or using certain forms. The issue of keeping the
ms-access design part, and the database window with the he tables hidden
DOES NOT require you use security.

Try downloading the 3rd example of mine here..and run it:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Now..tell me what you think? Can you view the tables? If you turn that above
example into a mde..then users will not be able to modify the forms and code
etc.

To see the settings, and now I setup that database..simply exit..and then
re-enter but HOLD down the shift key to by-pass the startup options....
 
Back
Top