Microsoft Access and Creating Programs
I first began working with Microsoft Access in 1995 when I created a database using Access for Windows 95. Since then, this professional database software has helped me to develop many applications for business, private and personal use. Not only databases but complete database solutions, end-user programs, and utilities to perform specific tasks and help automate repetitive tasks. My extensive knowledge of Microsoft Access and its interaction with other software has made it possible for me to successfully design and code many programs for a wide range of uses.
This utility can remove all compiled VBA code from an Access database and help fix corruption, improve performance, and eliminate strange errors. The program guides you through the process step-by-step.
- Clean and uncluttered wizard type interface
- Can decompile the database so you can start with a clean compile
- Option to create a backup file
- Option to compact and repair database
- Adds a sequential number after the name for duplicate files
This utility can import, export, delete and rename the modules and class modules listed under Modules in the Database window. The program displays the data in a TreeView control for navigation purposes.


- Can import, export, delete and rename modules and class modules
- Right-click TreeView control context menu
- Supports selecting multiple files
- Works with Access Database and Add-in files
This custom switchboard presents a login form to access your program and makes it easy to create a system of menus to navigate through. The template can be modified to your own specifications.


- Can easily create a system of menus for users to navigate through
- Uses a login form to access the program
- Secures the database and tracks audit history
- Automatically links tables and updates connection strings for pages
This utility can automatically synchronise your system clock with an Internet time server. The program displays the system time and the synchronised time and provides a list of time servers to connect to.

- Can synchronise your system clock with an Internet time server
- Uses Winsock control
- Select a time server from the list or enter your own
This utility can recover lost or forgotten database passwords which are different to user passwords. The program can also open a database for exclusive access allowing you to set/unset a database password.

- Instantly recovers the database password
- Can change and remove the database password
- Can open the database or another database for exclusive access
- Supports Access 2000, 2002 and 2003 file formats
This utility can create binary large objects from existing files and store them in a database Table and write binary large objects back to a file. The program allows you to choose a location to save files to.


- Can load the contents of an existing file into a Stream
- Can save the binary contents of a Stream to a file
- Right-click ListView control context menu
- Supports selecting multiple files
This utility can search through the registry and create a list of COM objects that match the CLSID or ProgID that was entered. The program displays the data in a TreeView control for navigation purposes.


- Can create a list of COM objects from the registry
- Can copy a CLSID to the clipboard or export contents to a Text file
- Can open a CLSID in the Registry Editor
- Right-click ListView control context menu
This custom template provides the basis for creating secure trial versions for Microsoft Access offering software copy protection for developers. The template can easily be modified to your own specifications.




- Can create secure trial versions of your Microsoft Access programs
- Can set the duration of the trial period
This utility can list all the Microsoft Office menu icons making it easy to determine the FaceId value of a particular icon. The program has controls for previous and next page and displays 100 FaceIds on a page.

- Can list all the Microsoft Office menu icons and their FaceId value
- Can navigate page by page through all the icons
This utility can search all modules within the current project an Access database and list any strings that match the information you entered. The program saves the results to Find.txt file in the program folder.

- Can search all modules within the current project an Access database
- Supports selecting multiple files
This utility can unlock and lock Microsoft Access MDE files allowing you to make design changes to your compiled MDE files. The program allows you to edit the forms, reports and macros in the database.

- Can unlock and lock compiled MDE files allowing you to make changes
- Can make design changes to forms, reports, and macros
This utility can register and unregister Type Libraries and ActiveX Controls. The program displays the action (ready/succeeded/failed) in a TreeView control for each file and processes all the files entered.

- Can register and unregister Type Libraries and ActiveX Controls
- Uses ListView control
- Supports DLL and OCX file formats
- Supports selecting multiple files
This utility can make the Registry Editor open to the registry path that was entered and accepts root keys in standard and abbreviated form. The program allows you to open multiple instances of the Registry Editor.


- Can open the Registry Editor directly to the key that you entered
- Can accept root keys in standard and abbreviated form
- Can open multiple instances of the Registry Editor
- Right-click Registry key control context menu
This utility can reconfigure the settings in your startup options including settings modified to prevent you accessing parts of the database. The program can disable this type of security and restore settings.

- Connects to an external database
- Displays all the settings in the startup options
- Can reconfigure and delete the settings in the startup options
- Works on databases with a startup form/page or autoexec macro