Microsoft Access Protection - Book Links

More Object Protection and Security Measures

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

Read Garry's MSDN article on security in Access 2007

How to setup and maintain Remote Queries
http://www.vb123.com/Toolbox/02_accvb/remotequeries.htm

Open the Access help and contents file and choose Index. Now select "IN Clause" and you will find some reasonable examples.

How to use RWOP Queries
http://www.microsoft.com/office/ork/2000/three/65t3_9.htm

Programming with Forms as Class Module
http://www.vb123.com/Toolbox/02_docs/classyforms.htm
 

Search your Access help for “Program with Class Modules” to find out more about how you can open a form.


Adding Database Tools To Excel Spreadsheets
http://www.vb123.com/Toolbox/98docs/excelbe.htm

Setting Permissions on Objects using ADOX
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrsettingpermissions.asp

Two and Three Tier DAP and Preventing Malicious Scripts
 http://msdn.microsoft.com/library/en-us/odeopg/html/deovrpreventingunauthorizedaccessfrommaliciousscripts.asp


Interesting Reading On Access Data Project Security
Click here

Documentation on MDE Libraries
http://my.advisor.com/doc/12298

Smart Access July 99 MDE References

Database Creations provides a solution for managing ADP security
http://www.databasecreations.com/prod_apsm.htm

A good explanation about MDE databases and PCode
http://www.papwalker.com/ref101/mde.html

If you have a database that needs a very simple protection mechanism, why not try the Access software at Peter De Baets website.
http://www.peterssoftware.com/las2.htm

How to saving your database as an MDE or project as an ADE File
Click Here

Discussions on Workgroup Security and MDE files
http://www.microsoft.com/office/ork/029/029.htm

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics

  • 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. 

    See the Smart Access 2010 specials here

  • 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.

  • Convert Access to SQL Server  
    Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query  translation and web form conversion.

 

 

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