If you found this site useful, please consider giving a donation to help offset the costs in keeping it running. Thanks.
Re: Speed Comparison Test 6 - Query vs SQL vs QueryDef.
Thank you for this information, very interesting. It's nice to see some data behind the claims.
Jeremy Lefort, WNYPropertyAlliance, USA
Thank you Colin for all your assistance in helping me understand and implement the Automatic Form Resizing code. Amazing work and the Zoom feature is awesome.
Kevin Baker, Developer, Database Designs LLC, Wilson, NC, USA
I have grown in the knowledge of Access applications by keenly following post on the Mendip Data Systems website which is a powerhouse of professional exemplified code examples. Thanks Colin for your selfless mind
Oliver Jaika, High School Teacher, Mbale, Kenya
I contacted Colin Riddington at Mendip Data Systems regarding a repair of a corrupted access database as all attempts to repair it myself had failed.
However, Colin offered to help and was able to recover the data in record time without any loss. I'm so grateful for his expertise, he's a lifesaver! We didn't have a recent backup and he has saved us so much time from redoing the data entry all over again.
Omar AlMatar, Hamad Medical Corporation, Egypt
Just found your site on a Google search. I REALLY liked it and intend to use some of your free code, as well as to read all your articles since I am a beginner in Access. Thanks! I made a small donation by the way.
Gerardo Hubard, Adley Developments Inc, USA
I want to extend a sincere thank you to Colin for sharing his time and expertise in MS Access. As anyone in the Access community knows, Colin is often the one to sort things out for message board posters when they run into challenges with Access. Colin recently guided me in a project that uses the Automatic Form Resizing code that he has worked on over many years. Colin is always patient and somehow is able to explain things clearly. I strongly recommend for anyone who wants to improve their own Access applications to look over Mendip Data Systems' wealth of articles and samples and feel free to reach out to Colin if you need a friendly hand to assist you. You won't regret it!
Jacob B, Access Developer, Toronto, ON, Canada
Thank you all for the work you do and for taking the time to make such good work available to other developers via your website.
Dave Thompson, Independent Access Developer, Allen , TX, USA
I am implementing a database-based application that will be used by the Information Services staff of our department. I needed a login system to make the program more secure, and the Password Login application from Mendip Data Systems was the answer.
The ease of importing the database into ours, as well as configuring to suit our environment resulted in its implementation in short order. Thank-you to Colin for authoring this great product.
Andrew Kaplan, Systems Manager, Massachusetts General Hospital, Boston, MA, USA
I would like to take this opportunity to express my sincere gratitude for the effective expertise provided by Colin Riddington at Mendip Data Systems. For the past few months, I have been trying to get a form to automatically fit different screen resolutions. During this time, I have posted questions in a forum on the subject and I have been searching the internet, but was unable to adjust the form successfully.
However, Colin offered his knowledge and experience and answered my design and development queries related to the topic in considerable detail. Colin provided me with the working solution on a copy of my database Once again, Colin receives my unconditional thanks as one of the best Access professionals.
Dori Imperial, High School Teacher, Murcia, Spain
As a Microsoft Access programmer for more than thirty years, I was delighted to find the Mendip Data Systems site. On their site, there are many database examples for download and I reviewed a number of them. From both a programming and aesthetic point of view, these examples were excellent. Based on this review, I am confident that Mendip Data Systems has the ability to produce very professional and useful databases for their customers.
Adam L., Senior Software Engineer, New York, NY, USA
I would like to take this opportunity to express my sincerest praise and gratitude for the effective consulting expertise provided by Colin Riddington at Mendip Data Systems.
Over the past few months, my organization has been redesigning its HR legacy database. During this time, we frequently posted questions in an Access developers' forum. Here, Colin offered his knowledge and know-how and regularly answered (in great level of detail) many of our database-related design & development inquiries.
Colin provided us with several database examples and even facilitated the functional integration of various Access solutions into our new database. Specifically, he assisted with the implementation of both an "auto shutdown" routine as well as the proper conversion of standard Access macros into VBA code (given the built-in macro conversion process yielded multiple errors). Again, Colin receives my unconditional endorsement as one of the very top performers in his profession.
Tom Bock, Management Analyst, Consolidated Analysis, Virginia, USA
One of my clients experienced severe data corruption in a split Microsoft Access backend database on the network. The network backup drive was also found to be non-functional. The only hope for this business to survive was to salvage data from the corrupted files. Some system files were lost, and all of the data storage tables behaved like system files. I posted my problem on a forum and Colin from Mendip Data Systems picked up the thread. He invited me to send him the damaged file, which I did. Within 24 hours he returned it to me with all tables, both system and data, working properly. The business owner and I are very grateful to Mendip Data Systems for saving us the time and frustration of completely rebuilding the back end tables of this database application.
Doug Happ, HappTech Databases, New York, USA
Colin from Mendip Data Systems always has a wealth of information and suggestions for our MS Access applications, I'm really glad there are people out there like him to help and share what they have learned. Would gladly recommend his advice and help in what ever you do. Thanks Colin. Much appreciated.
Robert S. Davis, Payfast Enterprises, Geneseo, NY, USA
I needed a reliable Log In / Log Out system for a MS Access database i was designing. Colin from Mendip Data Systems provided me with both the correct VBA code and forms to make it work within my existing system. I also had several questions regarding the implementation of the code which were answered very clearly and professionally. Highly recommended
Emma Ryan, Dublin, Ireland
I wanted a buzzer to go off when the user entered some invalid data. Three previous versions of essentially the same routine that point at a particular DLL I tried didn't work. Mendip Data Systems free Countdown Timer had a very straightforward approach to the sound play.
I pieced it into my application, and it worked the first time! Thanks a lot Colin!! Great work!
Brian Prenovost, Best Data Processing, Holiday, Florida, USA
I needed help with suggestions on designing a quotation system and found that Mendip Data Systems had a wealth of knowledge when applying Microsoft Access solutions and decided to approach them with my idea. The results I had received were informative and easy to understand, which made it simpler for someone who did not have an advanced knowledge of Microsoft Access.
I particularly liked how the solution was broken down into easier chunks to read and understand and was also very honest about whether something was simple or complex to achieve using Access.
I would recommend Mendip Data Systems to anyone that was looking for an Access solution as the information provided was both fair and concise.
Stuart Ginns, Tender Executive, Chromatography and Mass Spectrometry
Thermo Fisher Scientific, UK
If, having used Access for years, you believe that you can somehow manage almost everything by yourself, do look closely at the applications on the Mendip Data Systems website ... there are many free examples for you to try out.
Then, when your databases need highly professional attention, you will know who to turn to ...
Marco Baldari, Tuscany, Italy
Mendip Data Systems recently converted my business database application built many years ago using MS Access version 2.0 (from 1994) to the current version (2016), solving issues that I had wrestled with unsuccessfully for several hours. All database objects were successfully updated and the new version worked perfectly without any problems
This was a very professional and prompt service. Highly recommended
Dave Cheetham, Auckland, New Zealand
Mendip Data Systems have been very helpful in helping me to customize an application taken mainly from the free UK PostCodes example application and which is packed full of very useful features. I am looking forward to the release of his UK Postal Address Finder application which I am sure it will be of great benefit to organisations who require that little more, adding street addresses will only enhance what is already a fabulous product.
Les Hunter, Gloucestershire, UK
School Data Analyser is a fantastic resource and has enabled school leaders and classroom teachers to have real time access to a vast range of data and analysis tools in a quick and easily accessed format. It has played a central role in school improvement. The pastoral and mentoring sections have been particularly helpful and staff love how all the information on a particular student is all in one easily accessible place
Tony Sammon, Headteacher, Mendip Partnership School, Glastonbury, UK
School Data Analyser has revolutionised the way that we monitor the behaviour of our students. Before we used School Data Analyser there was paper everywhere, procedures were slow and time elapsed between incidents happening and consequences put in place. Now we have the information at our fingertips, tutors and heads of year can investigate rapidly and monitor their pupils easily. The extensive help and support ensures that staff are able to use all features effectively even if they are new to the program. The support we get with School Data Analyser is fantastic with rapid response times and clear explanations. Suggestions for improvement are well received and discussed so that the software is always being improved.
Stephen Spurrell, E-Learning Manager,
St Bernadette Catholic Secondary School, Bristol, UK
The Curriculum Enrichment Organiser database allows me to manage a complicated enrichment programme and keep accurate student data. Without this it would be extremely difficult to maintain such a vast number of variables. Having this program means that more time can be spent creating diverse learning experiences for young people which is paramount...
Abbie Edbrooke, Enrichment Programme & Educational Visits Officer,
Worle Community School, Weston-super-Mare, UK
If you would like to add a testimonial or other feedback, please enter your name and e-mail address below, select the application (optional), add your comment and press the submit button. Thanks