Microsoft Access Protection  and Security - Book Links

Securing Access Data

Is Your Database Secure ? Need to know more about how to protect your database investment. Confused about Access security. Then have a look at the book that Garry is writing for Apress.
Click here for book link

A wonderful paper from Visa Card International that provides many wonderful checklists for creating good office, human and computer security
http://www.visaeu.com/for_business/e-commerce_security/documentation/ais_questionnaire.pdf

Understanding MS Access Security  - Read
 http://www.microsoft.com/AccessDev/Articles/BApp97/chapters/ba14_1.htm

Determining permissions and many other user-level security issues
http://www.microsoft.com/AccessDev/Articles/BApp97/chapters/ba14_2.htm

How to use ADO with Visual Basic or VBA for Access Passwords and Workgroups
http://www.vb123.com/Toolbox/02_docs/accessadosecure.htm

Running the Access User Level Security Wizard in Access 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrrunninguserlevelsecuritywizard.asp

Notes on Access User-Level Security Wizard by Frank Rice, the technical editor of this book  
http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_AcSecurity.asp

The highly referenced Access Security FAQ paper
 http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Mary Chipman’s article entitled “Is Database Security an Oxymoron?” in Access / VB SQL Advisor
http://www.advisor.com/doc/11530

The workgroup Information file and command line startups
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrtheworkgroupinformationfile.asp

Newsgroup thread about putting command line arguments in code
http://groups.google.com.au/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=9357A9B9Fdfentonbwaynet%4024.168.128.78

Detecting the groups that the user is joined to
http://www.dbases.net/knowledge_base/security_user_group.html

RWOP and Lookup Tables
http://www.mvps.org/access/lookupfields.htm

A number of related security posts
http://www.dbases.net/knowledge_base/security_tips.html

Newsgroup discussion on Access Security and forcing of passwords
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/181/qid/337243

Windows Authentication Security In SQL Server
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

Access Security Notes
http://www.moretools.com/lessons/access_security.htm

Changing Queries to RWOP
 http://dbforums.com/t581239.html

View Your Access Reports on an Intranet using the SSW Report.Net software
http://www.ssw.com.au/ssw/AccessReporterForIIS/

Books - Articles - Help Guides

MS Office Developer 2000 or 2002. Visual Basic Programmers Guide

Smart Access Aug 2001 - Workgroup security
Smart Access  - August 1999 PID's etc

Search Access help for “Command Lines”

The PID authentication approach is suggested in Access 2000 or later help if you search for “workgroup information files” and then look for the topic “Setup more than one workgroup to manage the same secure database”

Pages Added Since The Book Was Published

How to Use IDC Files to Query a Secure Microsoft Access Database
http://support.microsoft.com:80/support/kb/Articles/Q161/1/72.asp&NoWebContent=1

How to remove User-Level Security from a Database
 http://www.microsoft.com/office/ork/2000/three/65t3_8.htm

Chapter 16 of the Access 2003 VBA Programmers Reference by Graham Seach and others is a good reference on programming Access User Level Security Click here

Samples of Data Security and Database Passwords

A page covering Access 97 workgroup security, database passwords, replication and other security issues
http://www.microsoft.com/technet/archive/office/office97/reskit/office97/029.mspx

Access 2000 Replication and Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsecuritydatabasereplication.asp

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
  • Get Good Help
    If you need help with a database, our Australian Professionals could be the answer

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection. 

    Purchase Smart Access

  • The Workbench
    Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions,  shutdown database

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc. Includes one of Smart Access downloads.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.
  • Purchase the Popular FMS Products  
    If you purchase the Popular FMS products from us, you will receive a complimentary of Smart Access Gold, Silver or Bronze Collections [Your choice]

 

 

vb123 Professionals


Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions


Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.


About The Editor ~ Contact Us
Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia

Access 2003 Security

MS Access Security

Read More here