vb123.com

 

Home Page 
Order Our Software

The Workbench  Find out who is in your database, open the correct version of Access, easy compacting, switch workgroup files with no fuss Click Here

The Toolshed 
Ebook comprising of all the information at vb123.com plus hidden downloads etc. Click Here

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool.  Click Here

The Toolbox  Easy to use source code that you can import into your Access database. 
Click Here

Access Security 
Garry's book on Access Security will be hitting the streets soon. In todays Real World, can you afford not to have a secure database?

Note: You can find a good price if you
pre-order now at Amazon
Read More


Free Newsletter  Try our informative newsletter on Office Automation, Access and VB topics
Click Here

About The Editor Garry Robinson writes for a number of popular computer magazines. He lives in Sydney, Australia and runs VB123 and GR-FX.com
Contact Us ...

 

   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/toolshed/02_docs/accessadosecure.htm

A page covering Access 97 workgroup security, database passwords, replication and other security issues
http://www.microsoft.com/office/ork/029/029.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”

Links >>>  Home | Search | Workbench | Orders | Newsletter | Table Of Contents | Access Security