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