Samples of How To Manipulate Access Options and Attributes

With these samples you will learn how to
Object Name Access Version Click Picture to View	Topic	Object Type
frmGeneralOptions 2003 2002 2000	Turn off/on compact on close and MRU in Access 2000 and 2002 using visual basic.	Form
frmEditFindOptions 2003 2002 2000	Change the Edit and Find Properties of the database using visual basic.	Form
frmAdvancedOptions 2003 2002 2000	Update the shared and open exclusive properties of the database.	Form
frmHiddenAndSystemObjects 2003 2002 2000	View and hide system and hidden objects in the database window. Show how to hide objects and make tables a system table. List all the hidden and system objects in your database.	Form

Your Access 2002/2003 sample database file is called "grMap2002.zip"

and your Access 2000 sample database file is called "grMap2000.zip"

If you do NOT own "The Toolbox", Click here to find out how to purchase The Toolbox.

Find Out More

These samples are discussed at length in Chapter 4 of Garry's Book on Access Protection and Security Read More

Click on the following button to jump to the next page in the protection samples loop.

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.

Purchase the Popular FMS Products
If you purchase the Popular FMS products from us, you will receive complimentary copies of our software

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