Free sermons and illustration databases designed especially for Evangelical Christian workers
MS Access version of the Kerux Database
Feature (November 2017) - double-click on a topic in the TOPIC
line and an instant search will be initiated. This helps you follow your
creative thought process as you do your research.
The Kerux2010 version can be used by anyone after installing the free Microsoft runtime file. Very powerful, with automatically adjusting forms, unified searches and data mining functions. The Access97 version is now retired.
|Inner links:||Main installation files - SID or Access2002|
|Illustration collections / supplements|
|Sermon collections / supplements|
|History of uploads and software developments|
|Plea for help on future developments|
|Information on updating your database (more thorough advice is here)|
|Summary of who uses the Kerux database.|
(Click on blue filename to begin download)
|Access installation files||Kerux 2010|
contains the entire database in the new Access
2010 format, designed by Edward Barclay, which is compatible
with both 64-bit and 32-bit systems. This is the standalone version,
which means anyone can use it, even if you don't own MS Access.
It is self-installing and creates a directory on your hard-drive
and puts an icon on your desktop. It is a big file, so
don't try it with a dial-up modem. The mega-database contains over
35,000 sermon illustrations and 25,000 sermons. To check out the new
features check out the
online help file, which is somewhat out of date now.
Please report any issues you experience with
the database so we can fix them.
If you have Windows10 and Kerux2010 will not run after you install it, or you get the error message "Unable to load odbcji32.dll", read this.
If Windows Defender says "Windows protected your PC -- unknown publisher" then check "more info" and then "Run anyway"
Summary of installation:
2. The online registration asks a few questions that give me insight on who is using the database. This summary is all that is ever shared about users. I do not share your information with anyone else. The password will appear on the screen as well as the link to the mega-database download..
3. When you download the database, the Mega website requires the Firefox or Chrome web browsers (both are free). Click the Mega website box that says you agree with their terms of service, then click "Download" and save it to your computer hard-drive. With Firefox, you have to allow it to install a special add-on for downloading large files like this.
After the download is complete, you double-click the file on your hard drive. You will be prompted for the password, which showed up on the confirmation screen when you registered online.
4. Many of the programming issues have been fixed in this version. Let me know what you like about it and what you would like to change -- and especially what doesn't seem to work..
Nov 5, 2017
|The latest version of the help-file, which is also included in the mega-database above. It contains a tutorial and extensive links to help you get the most out of the program.||2 meg||
Mar 5, 2016
|If are already using the Kerux2010 version, download and install this file. A new feature is the ability to double-click on a Topic, which generates a new set of records to review. This file fixes the issues with import and export of supplements. It does not contain any data files (sermons and illustrations which are contained in KeruxData.mdb) but it upgrades the database software. No password necessary, just unzip it and copy the files into your Kerux directory. If you want to work with the code within the program, rename "Kerux2010.accdr" to "Kerux2010.accdb".||5.5 meg||
Nov 5, 2017
contains the entire database in the MS Access
2002 format. It is self-installing and creates a
directory on your hard-drive and puts an icon on your desktop.
The mega-database contains over 35,000 sermon illustrations
and 25,000 sermons.
This version allows supplements to be imported, which fixes a previous error.
After the download is complete, you double-click the file on your hard
drive and it will prompt you for the password.
Nov 5, 2017
A Note on Update Capabilities
A series of buttons allows users to download special datasets which update the database records automatically. For updates to work properly you should have at least version 5.3 which has the Import button on the Intro pop-up screen - previous versions will not work properly. The help file (new versions of Windows require this free file to view the help file) has instructions on how to transfer your data tables from a version prior to 5.3 to the newest version. Many sermons and illustrations do not have complete topics or secondary Scriptures entered, but as I update these on my own database I will make a file with just those changes and put it on this page. You will download a much smaller file and your existing database will be brought completely up to date. I also include instructions on changes you will have to make on your end. Always back up your database before updating it. (see warning below for some helpful advice)
Every Access user of this database should have the version that includes the "Update the Database" button on the Intro PopUp screen. (SID puts this on an icon called IMPORT) This function works with a table called tblCommand in the supplement files table so your existing database (version 5.1 and up) can add the new sermons and illustrations automatically. It will also update your existing ones. The sets and supplements here are usually lacking three fields - the Rating field, any personal note field like "Date Used" and the "do_not_update" field - so your personal data will not be erased. This also means you cannot just copy this material and paste it in your tables.
Access users can manipulate the tblCommand table to allow you to update several tables at a time. But be careful - multiple large files will cause the error message "database is full." This can happen even if you update the sets separately. Your database is not really full, but your RAM memory is maxed out. This is a serious error message because it can lead to corruption in your database. Close the program, launch it again, and compact the database by going to the Menu Bar and clicking TOOLS, then DATABASE UTILITIES, then COMPACT THE DATABASE. It is a good idea to compact it after each large supplement or set.
If you (Access users only) are trying to do a major update with an entire "Holwick's Illustrations" or "Sermons" table (not just one of these sets) you will probably have to use a Make Table Query to break up the table into smaller chunks, then compose a tblCommand that references each chunk. The help file has an index entry for Make Table Queries that will show you how to do this.
A few times a year I will update all the main data sets and this will make the incremental supplements redundant. I have been grouping each year's changes in large supplements. Be careful - any changes you have made to these illustrations or sermons will be overwritten. Use the COMPARE feature to check out your database with the supplement. Also, read the description of each file carefully.
Warning BACKUP BACKUP BACKUP
Three times now I have wiped out my database. It makes me thankful that I have put all this material on the internet, but I have always lost several weeks of work when this happens. The warning to backup your database should be taken seriously. In my opinion, there is only one practical way to do this - I recommend getting an external hard drive. For around $100 you can get one that holds over 100 gigabytes. They are fast, you can program them to do massive backups overnight, and you can store it in a different location so a fire or other disaster does not wipe out your backup, too. "A prudent man sees danger and takes refuge, but the simple keep going and suffer for it." Proverbs 22:3
For those who are not prudent, I now offer a database recovery service. If your database (Access97 and 2002 only) becomes corrupted and you cannot open it, burn the database onto a CD or DVD and mail it to me. For $49 I'll recover it and send it back on another disk. If I cannot recover it, you don't pay. This service is for those who have accumulated a fair number of their own illustrations which they don't want to kiss away.
Where We Need Help
The Kerux database has seen tremendous improvements through the contributions of Christian computer programmers around the world. Currently we are trying to work out some bugs in the Import/Export feature and add a few new features. If you know how to program in Access, send me an email.
Go to homepage, Holwick.com
Go to sitemap
for links to other files.