Peter's Software
Helping you create better Microsoft Access applications

Home

General info

Where to buy

Mailing List

Contact

Links


 

 

Application Beginnings

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!


Stage 1

Use an autoexec macro to run a special function from a special module that handles houskeeping tasks related to application startup.

Download ab1.zip - For Access 97, 2000, 2002/XP, 2003 (84 KB)

Stage 2

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.

Download ab2.zip - For Access 97, 2000, 2002/XP, 2003 (328 KB)

Stage 3

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.

Download ab3.zip - For Access 97, 2000, 2002/XP, 2003, and 2007 (501 KB)

Stage 4

Maintain a persistent recordset connection with your database back end to eliminate an annoying multi-user performance issue.

Download ab4.zip - For Access 97, 2000, 2002/XP, 2003, and 2007 (525 KB)

Stage 5

Coming soon...

Instructions

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.

Please see the included readme.txt file or help file for further instructions on application usage.


Technical Support

For technical support for this application, please send an e-mail message to: info@peterssoftware.com


Price

Free!

 

Comments?