Access FAQ - File Downloads

Some essential files for working with Access

Last Updated 20 June 1999

Table of Contents
The links here will take you to a description of the file
Access FAQ (MDB) Sourced from Compuserve
Access FAQ (HLP)
Access 2.0 Service Pack
L/R Naming Standards
A startup Application
Popup Tools
Toolbar Resetter
Domain Function Replacement
More Popup tools
A Typical Access Application?
TBLIB - Add-in (New 32 bit version)
Repair And Compact Tool
File/Open Common Dialog (32 bit)
A Rude one?

MS Access FAQ in MDB format. (137KB ZIP File)
This was downloaded from compuserve and contains more questions than you see here, although I did add some in myself (the questions here).
MS Access FAQ in HLP format. (1997KB Self extracting EXE File)
The Microsoft FAQ for Access 2.0
MS Access 2.0 Service Pack. (1923KB Self extracting EXE)
This will upgrade your Jet Database Engine to version 2.50.1606, you'll need to do this to run the latest OCX embedded objects, it also fixes a few bugs inherent in the original setup of Access.
L/R Naming Standards Database. (24KB ZIP File)
This database, when opened will instantly run a report giving the Leszynski/Reddick Naming Conventions for MS Access. For more information why it's a good idea to follow these standards, click here.
Startup Database. (29KB ZIP File) This is loaded with goodies.
I use this myself, instead of just starting access, I start this database, it contains a list of all my regularly used databases (rather than the last 4 on the file menu), from there I can open the selected database or even go into maintenance mode and repair/compact it. The db is not secured so you can go into design mode and see some of the techniques used, particularly getting the Windows File/Open dialog to appear, A simple wizard, how to open another database from within the first database, how to get a database to compact itself and how to change the title bar text on the fly.
This list of databases will appear in the following order, most recently opened first, then in decending order of popularity based on number of times that db has been opened.
A note worth mentioning, I wrote this db some time ago, before I started using the L/R naming standards so I thought I'd better warn you before you start emailling me to practice what I preach.
Popups Database. (29KB ZIP File)
A small mdb containing a few popup forms that you can call up from your forms to add functionality and ease of use to your applications.
For text boxes you can use the Zoom box, like [Shift]+F2 but bigger and with customisable font & font size / style selection.
For numeric fields, there's a calculator that will return the result straight to your field.
And lastly, for dates there's the calendar, just like the OCX one that ships with the ADT but uses no OCX.

And there's no need for any programming on your part because I've done it all for you, just import all the objects into your database and you can just set a fields double click event property to a simple function call, e.g. =PopupCalc([MyField]).

Popups Database - German Version (HTML Link)
As English Popups but translated into German by Ulrich Denker.
Toolbar Resetter. (8.5KB ZIP File)
This database, when opened will instantly reset your toolbars to show "Where Appropriate" for when things have gone a bit adrift.
Domain Function Replacements (1.6KB ZIP File)
Replacement for domain functions, DLookup, DCount, DSum, DMax & DMin.
Tools.mdb - Another popup (32.2KB ZIP File)
Popup Calculator & Calendar like in popups.mdb but the popup form will popup next to the control it is launched from. This was submitted by Keith Altenhof Kaltenho@acs.ucalgary.ca
Typical Access Application (11KB ZIP File)
Actually it`s a joke app but it shows what Access can do, it contains one form and has a scrolling marquee effect on it.
TBLIB (198KB ZIP File) As featured in PC Welt
Database Add-in (version 2.00) that gives you the following functions:
Database Window (Enhanched)
Print Table Def (Simple 1 line list with field name, type, size and descriptions)
Attach Manager - Allows creation of new attachments (in bulk so not much clicking involved)
Simple Options screen for Toolbars available, Show system Objects, Arrow key behavior and default open mode
Import Tool - Select objects for import then import them in bulk
Tab Order Tool - Point and click tab ordering for forms.
Popup Menu Tool
Routines And Functions callable from code
Click here for the 16 bit version for Access 2.0
New 32 bit version for Access 97 has the following extras...
Error Trap Builder for VBA Code.
Control Renamer, renames all controls on a form to L/R naming conventions.
Search & Replace Tool.
Turn off all form Timers.
Check for SQL reserved words in table/column names.
Database window now has filter for easier access to your objects (and the "New" button now works:)
Search for missing relationships.
420K Zip file
Repair An Compact Tool (2.5MB Zip)
Seaches any number of disks, seeks out all Ms-Access databases then Repairs and Compacts them
Available as 16 bit or 32 bit versions.
File Open Common Dlg (32 Bit) (3K Zip)
Complete Module in Text (.txt) file, just import as a new module into your database.
A Rude Database? (22K Zip)
OK it has a rude name and asks a personal question of any man but it's fun, you can adapt it to your own needs. The infamous elephant button (runs away from the mouse).

o your own needs. The infamous elephant button (runs away from the mouse).