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.

Access Decompile

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.

Access Decompile Microsoft Access Decompile Database WizardAccess Decompile Select DatabaseAccess Decompile Optional CommandsAccess Decompile Finishing the Access Decompile Wizard
Features
  • 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
Export Module

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.

Export Module Microsoft Access Module Utility
Export Module Right Click Menu
Features
  • 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
Switchboard

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.

Switchboard Login Form
Switchboard Microsoft Access Custom Switchboard Template
Features
  • 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
Synchronise Clock

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.

Synchronise Clock Microsoft Access Synchronise System Time Utility
Features
  • Can synchronise your system clock with an Internet time server
  • Uses Winsock control
  • Select a time server from the list or enter your own
Access Password Recovery

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.

Access Password Recovery Microsoft Access Database Password Recovery Utility
Features
  • 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
Blob

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.

Blob Microsoft Access Binary Large Object Utility
Blob Right Click Menu
Features
  • 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
COM Objects

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.

COM Objects Microsoft Access COM Objects Utility
COM Objects Right Click Menu
Features
  • 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
Expiry

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.

Expiry Licence
Expiry Trial Window
Expiry Enter Product Key
Expiry Microsoft Access Software Copy Protection Template
Features
  • Can create secure trial versions of your Microsoft Access programs
  • Can set the duration of the trial period
FaceId Explorer

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.

FaceId Explorer Microsoft Access FaceId Explorer Utility
Features
  • Can list all the Microsoft Office menu icons and their FaceId value
  • Can navigate page by page through all the icons
Find

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.

Find Microsoft Access Search In Code Utility
Features
  • Can search all modules within the current project an Access database
  • Supports selecting multiple files
MDE Unlocker

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.

MDE Unlocker Microsoft Access Compiled MDE Utility
Features
  • Can unlock and lock compiled MDE files allowing you to make changes
  • Can make design changes to forms, reports, and macros
Register Dll

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.

Register Dll Microsoft Access Register Dll Utility
Features
  • Can register and unregister Type Libraries and ActiveX Controls
  • Uses ListView control
  • Supports DLL and OCX file formats
  • Supports selecting multiple files
Reg Jump

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.

Reg Jump Microsoft Access Jump To Registry Key Utility
Reg Jump Right Click Menu
Features
  • 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
Startup Properties

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.

Startup Properties Microsoft Access Startup Properties Utility
Features
  • 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