Mendip Data Systems

Database applications for businesses and schools

LogoTransparent
* 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 Database Applications                     Page 4 (of 4)

1 2 3 Return To Top
Page 4 of 4

List External Tables

Version 1.6      Updated 05/11/2018            

 

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

4

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 4.0      Updated 13/11/2018            

 

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