These are some example databases that show startup processes for an effective, professional Microsoft® Access® application. Feel free to copy them and use them as part of your application. Start with these samples before you create your first form or table!
Use an autoexec macro to run a special function from a special module that handles houskeeping tasks related to application startup.
- For Access 97, 2000, 2002/XP, 2003 (84 KB)
Deal with references. Check library references, try and fix them if broken, report broken references and quit if they can't be fixed. Also, set a DAO or ADO reference according to your application's needs.
- For Access 97, 2000, 2002/XP, 2003 (328 KB)
Refresh table links. Two tables in your application front-end hold the database names and table names for the linked tables in your database. This procedure deletes and re-creates each link on application startup.
- For Access 97, 2000, 2002/XP, 2003, and 2007 (501 KB)
Maintain a persistent recordset connection with your database back end to eliminate an annoying multi-user performance issue.
- For Access 97, 2000, 2002/XP, 2003, and 2007 (525 KB)
Double-click the downloaded zip file to open it, then extract the .mdb file corresponding to your Access version to a folder on your computer. Double-click the extracted .mdb file to see the demo.
the included readme.txt file or help file for further instructions on
support for this application, please send an e-mail message to: firstname.lastname@example.org