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

The Developer Workgroup Security Strategy

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 useful paper on many aspects of Access security by Frank Rice, the technical editor of this book  
http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_AcSecurity.asp

Securing your database without asking user to log on by Microsoft
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrsecuringyourdatabasewithoutaskinguserstologon.asp

The very highly referenced security Frequently Asked Questions 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 confirmed and improved on the theories behind the developer workgroup strategy
http://www.advisor.com/doc/11530

A good exposition of the developer workgroup strategy
http://www.advent-it.co.uk/SecureMicrosoftAccessdatabasedevelopment.htm

Find out all the specifics about owners, groups, SIDs and the Admins group.
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrusersgroups.asp

Securing your database without asking your users to log on
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrsecuringyourdatabasewithoutaskinguserstologon.asp

A short but definitive article at Microsoft on how to secure a database including permissions for newly created objects.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q289885

Workgroup security explained in detail by Microsoft http://www.microsoft.com/office/ork/2000/three/65t3_6.htm

How to use ADO with Visual Basic or VBA code with databases that are protected by Access Passwords and Workgroups
http://www.vb123.com/toolshed/02_docs/accessadosecure.htm

To find out about the different types of permissions for the different types of objects, type “permissions” into Access help.

Upgrading DAO to ADO
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate_topic13.asp

Programming user security with VBA code
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrusingvbacodetoworkwithuserlevelsecurity.asp

No permission to convert database error
http://support.microsoft.com:80/support/kb/articles/Q232/5/89.ASP&NoWebContent=1

Database security and replicated databases
http://msdn.microsoft.com/library/en-us/office97/html/changestoyourdatabase.asp

Why use database replication ?
http://msdn.microsoft.com/library/en-us/office97/html/whyusedatabasereplication.asp

More details on the Admin Account and Admins and Users Group
http://www.vb123.com/toolshed/03_map/predefined.htm

Pages Added Since The Book Went To The Printers

Lyn Trapps User-Level Security Page
http://www.ltcomputerdesigns.com/Security.htm

 

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