vb123.com.au
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/Toolbox/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/Toolbox/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
Samples of Data
Security and Database Passwords
Our Tools and Resources
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
