To provide feedback on an example database, please enter your name, e-mail address and company (optional) below, add your comment and press the submit button. Thanks
The applications on this page are free to download and free to use.
Almost all items are supplied with full program code and will work in both 32-bit and 64-bit Access unless stated otherwise.
We do not give the same support to these programs as for our commercial programs.
However, please contact us if you have questions or suggestions for improvements.
If you found this site useful, please consider giving a donation to help offset the costs in keeping it running. Thanks.
This utility will list all tables in selected external databases. Users have the option of selecting any/all of the following types of table: hidden/system/linked
It will work successfully:
a) with ACCDB / ACCDE / MDB / MDE files
b) with password protected files where this information is entered on the main form
c) on the current database
d) in 32-bit or 64-bit Access (there are no API declarations)
More Details ...
This is a companion to the Colour Converter / Selector example
In earlier versions of Access, only 3 colour formats could be applied whether using VBA or the conditional formatting wizard. From Access 2010 onwards, the limit was significantly increased to 50 using the wizard but the limit of 3 formats still applies using VBA.
This example shows how to obtain an unlimited number of colour formats without using
conditional formatting either in VBA or by using the wizard.
This is an updated version of another old utility written by David Crake and is a companion to the Logged In Users utility
I have converted it to ACCDB format and modified the code so it will work in any version of Access from 2007 onwards (32-bit or 64-bit)
Other changes include stronger encryption of passwords using an RC4 cipher, management of expired passwords and user access levels
The Jet ShowPlan feature is used to view the execution plan of Access queries and SQL statements. The query execution plan is a set of instructions to the database engine that tell it how to execute a query as quickly as possible
In order to use the JET ShowPlan feature, you first need to setup the feature in the registry. This requires knowledge of the correct locations for several registry keys, some of which depend on Windows & Access versions & 'bitness' and whether Office 365 is installed.
The JET ShowPlan Manager application is designed to make this process as simple as possible