Samples of Good Access Programming Practises

With these samples you will learn how to
Object Name Access Version Click Picture to View	Topic	Object Type
AutoExec 2003 2002 2000	The autoexec file runs automatically when your database first opens. You should use this in all your databases. Read more	Macro
basAutoExec 2003 2002 2000	Module to demonstrate functions called from the Autoexec macro	Module
frmRelinkDatabase 2003 2002 2000	This form will open the link manager function where you will locate a back-end database with a name that you pass in the arguments of the function. Once that database has been located and the table is found, all the tables will be relinked to that database.	Form
basGR10_Files 2003 2002	A module that will refresh the table links. If the back-end database does not refresh properly, the user can locate it with the Windows File Dialog.	Module
basGR8_RefreshTableLinks 2000 97	A module to refresh table links	Module
basGR8_Startup 2003 2002 2000	Includes OpenForm and OpenReport functions, userlogging, find current path of database and change window headers.	Module
frmErrorHandling 2003 2002 2000	Show different ways of handling errors using visual basic including no error handling, conventional error handling and continue on error handling.	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 of good programming practices 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
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