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


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
 

 

Next Tip  Samples of How To Manipulate Access Options and Attributes

The samples shown on this page are for owners of The Toolshed. ... Download Sample

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

Sample Databases

  Click here for the Access 2002/2003 sample database file
  Click here for the Access 2000 sample database file
 

Else Click Here To Purchase if you don't own the Toolshed

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 Next Tip to jump to the next page in the protection samples loop.

 

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