Clean Data Systems . com

Freeware 'Add-In' data tools for Access 97, 2000, 2002, and 2003:

UnTools -- Tools to help you Explore, Repair, and Improve your data structures and data

DataDict -- Two minutes from your Access database to a printable Data Dictionary

qryTimer -- A shell for your queries; show run times, properties, and disable confirmations

NEWS
UnTools and DataDict were included on the CD with the Access 2003 Bible (click here for the software listing)
UnTools gets a nice review in the October 2002 issue of "Inside Access" - thanks!

All of this stuff is done during my mythical free time. Encourage me with an email!
Comments, suggestions, and bizarre data structure tales:

Click here for a brief word About Donations
Hosting and development tools are not free. Only your support will keep the site up and software free!
If you find these tools helpful in your work, please consider making a donation.

If you need web hosting, you can help me out by signing up with SiteGround (I get a referral credit)

Power Tools for Data Handlers

UnTools -- Tools to help you Explore, Repair, and Improve your data structures and data

LAST UPDATE 2003-03-30 Version 1.01 build 53

Screen shots of the Tool tabs: UnClear UnField UnPivot UnList UnMatch UnCode UnDaTe Prefs

Read Me: UnTools ReadMe file

Help/How To: UnTools_Help (pdf – 352 Kb -- right click to download using 'Save As' )

History: UnTools History file

Current Download version 1.01 build 53 2003-03-30

Add-In for Access 97 – UnTools97.zip (246 Kb)

Add-In for Access 2000 - UnTools2K.zip (270 Kb)

Add-In for Access 2002 (XP) - UnToolsXP.zip (270 Kb)

Add-In for Access 2003 - UnTools03.zip (270 Kb)

DataDict -- Two minutes from your Access database to a printable Data Dictionary

New Version 2003-04-02 - First Add-In release! (minor fix) Version 1.00 build 52

Open DataDict from the Add-In's menu within your database, and click the Refresh button.

Then preview/print a Data Dictionary or Loading Order report, or browse how you've defined your tables and fields.

Screen Shots: Sample Dictionary Report Page Sample Loading Report Page Table Browser

Read Me: DataDict ReadMe file

Help/How To: DataDict (pdf – 24 Kb -- right click to download using 'Save As' )

History: DataDict History file

Current Download version 1.00 build 52 2003-04-02 (minor fix)

Add-In for Access 97 - DataDict97.zip (155 Kb)

Add-In for Access 2000 - DataDict2K.zip (174 Kb)

Add-In for Access 2002 (XP) - DataDictXP.zip (175 Kb)

Add-In for Access 2003 - DataDict03.zip (175 Kb)

qryTimer -- A shell for your queries; show times, properties, and disable confirmations/warnings for action queries.

FIRST BETA RELEASE 2003-03-30 Version 1.00 beta 7

This is a pretty simple tool that I made to time queries, and then added some other things.
It's not done yet, because now I can think of lots more it could do...;-)

Try it out. Let me know what you think

Add-In for Access 97 - qryTimer97.zip (35 Kb)

Add-In for Access 2000 - qryTimer2K.zip (49 Kb)

Add-In for Access 2002 (XP) - qryTimerXP.zip (52 Kb)

Problems downloading? I've had a few people email me saying that a zip file is corrupt. Thank you for not just giving up; I do appreciate it.
Downloading has been successfully tested from different machines/locations, and it appears to be fine.

If you are using download assistant software, disable it temporarily and try the download without it. Or, try again from a different machine.
Or, Email me and I can send an attachment.

If you need a zipping/unzipping tool, check out NoNags for great freeware.
This link is (hopefully) the main category menu; look in Essentials, Compression Utilities.
www.NoNags.com