vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


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

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

About The Editor 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
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

   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/Toolshed/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/Toolshed/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/toolshed/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

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals