Neal Kling's Download Page

Downloads

   * Dave Bell's Proper Case Database (New 9July1999)
   * My Access 97 Back End Update Functions and Database (New 5Jun1999)
   * My Access 97 Runtime Reference Management demo (New 26Mar1999)
   * My Access 97 Text File Import demo
   * Anita Smith's SQL Learning Tool
   * My freeware utility to reset Access database Startup Properties
   * My Access 97 MSComm32.OCX demo
   * My Access 97 Custom Logon Demo

Dave Bell's (aka Rafterman) Proper Case Database Functions and sample database for applying proper case rules. Any proper case can be handled through the use of an exception table.

Download ProperCase.zip 174KB
Back to Top

Access 97 Back End Update In this download you will find functions to create, delete and modify fields, indexes, properties in, and links to your back end.

Download BackEnd.zip 42KB
Back to Top

Access 97 Reference Management This demo contains a form and module that can be used to check, remove and add references at runtime. This code will run even in a project with broken references allowing you to provide your users with runtime reference management.

Download References.zip Version 1.1a, 77KB
Back to Top

Access 97 Text File Import This is the demo mdb and related files that I used during my March 24, 1999 presentation to the Access User Group of San Diego. It shows how I handled importing a text file with multiple record types. The import requires conditional handling of different record types and the maintenance of relational integrity during the import.

Download Import.zip 104KB
Back to Top

Anita Smith's SQL Learning Tool Anita Smith's SQL code tester. Bang in your code with the help of list boxes of available tables and fields. Select from SQL commands which are automatically pasted to the SQL window with prompts for appropriate info. Then test it! Nice help for SQL commands. Anita can be contacted at ozdane@dragnet.com.au

Download SQLWizrd.zip 74KB
Back to Top

Access 97 Database Unlocker There are a number of Access database properties that are commonly used to limit end users' abilities to gain access to a database. Sometimes they can be set accidentally or without realizing the consequences (that you've just locked yourself out!). These properties are: Allow DB window, Show statusbar, Allow built-in toolbars, Allow full menus, Allow break into code, Allow special keys, Allow bypass key and the Startup form. This utility allows you to toggle the selected properties to allow entry/access.

Download Mdbunlok.zip 3MB
Back to Top

Access 97 MS Communications Control I recently had the occasion to convert an Access 2 database to Access 97. It included serial communications using API calls. Rather than rewriting the API calls I used the MSComm control. I put together a little database to learn the ins and outs of this control and I'm now offering it as a demo. I also used the common dialog box and status bar control. You will need the following OCXs to make it work: COMCTL32.OCX, COMDLG32.OCX and MSCOMM32.OCX. I got my copy of MSCOMM32.OCX with Visual Basic.

Download Commtest.zip 75KB
Back to Top

Access 97 Custom Logon This is a demo of a custom logon form validating against an employee table with passwords. Use this when you don't want to use Access security for logon purposes. Demo saves employee ID to a global variable for use in event/error/etc logging, or to construct your own menu/form/etc permissions.

Download LogonDemo.zip 43KB
Back to Top

VB6 Runtime Support Sometime in the not too distant future, in order to save space on my site, I'll distribute VB stuff without the runtime support files. Then you can get the support files from Microsoft.

Download VB6 Runtime Files 1,031KB
Back to Top

Return to my homepage.