Private: cr-lookupsqlmode


Lookup is a simple yet powerful client for searching Microsoft Access databases. Originally developed in 1998 for Office 97. Lookup provides the easiest way to search and extract data from Access databases, run multiple network users all searching information and increase productivity.

Lookup can autoload a specified database to a specific table or query and field setting. Access allows databases from a majority of sources to be imported or linked and Lookup is able to read any linked or imported tables or queries providing unlimited flexibility. You can even link data from excel spreadsheets to Lookup through Access databases. Advanced features assist with spacing columns, a clock (with calendar feature), open and close hours for shops, a customisable other programs list, adjustable font size, csv search log, debug mode, SQL mode (for complex searches), ability to select tables or queries, saved searches, last 10 searches, automatic value picklist, advanced filter function with Clear button undo functionality and a formatted export to Excel. This little program is feature packed yet still small and simple. With over ten years of in the field testing and numerous revision focused on usability and flexibility Lookup is rapid, resilient and reliable for any business.