Samples of Good Access Programming Practises

vb123.com

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

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

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox 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

Samples of Good Access Programming Practises

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

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