Mendip Data Systems

Database apps for businesses, schools and developers

* Required

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.

iStock_000002894402Medium iStock_000005251211Large-LOW-RES education tools american-coffee-colleagues-1376871

Example Databases                     Page 4 (of 4)

1 2 3 Return To Top
Page 4 of 4

View External Tables

Version 2.3      Updated 28/11/2019            


This utility will list all tables in selected external databases. Users have the option of selecting any/all of the following types of table: local/ hidden/system/linked.


You can also view and (optionally) edit the contents of almost all external tables from the utility without actually linking the tables


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


Colour Conditions

Version 2.0      Updated 08/11/2018            


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.


More Details ...

Password Login (with Session Login Information)

Version 5.3      Updated 17/02/2020            


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


More Details ...

JET ShowPlan Manager

Version 2.4      Updated 17/12/2018            


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


More Details ...

UK Postcode Address & House Price Lookup

Version 1.2     Updated 10/12/2019          


This app is used to get a list of addresses & house price info for selected UK postcodes together with the geo-coordinates and a static Google map for that postcode


NOTE: This is a free cut down version of the UK Postal Address Finder app available as an ACCDE executable file. Source code can be purchased separately if required


More Details ...

View & Edit Import/Export (IMEX) Data Task Specifications

Version 2.2      Updated 10/01/2021            


A new wizard driven XML based system of Import/Export Data Tasks was introduced with Access 2010. However, ease of use has also led to greater obscurity in how it works


This utility can help manage these IMEX data tasks. It contains code to do the following:

a)   View Import/Export Specifications

b)   Execute Data Task / Run Data Task

c)   Modify Data Task Path

d)   Modify Data Task Destination

e)   Rename Data Task

f)    Delete Data Task


The utility is intended for use by program admins when deploying ACCDE or ACCDB files


More Details ...