===================================== M D B D I F F R E A D M E . T E X T ===================================== VER 2.05, BLD 1 - BUG FIXES --------------------------- - Fixed bug found by user where tables and fields possessing a Validation Rule property, or a Validation Text property that had a quote or single quote, would halt the operation. Went back, and run ReplaceQuotes() function on those properties too to resolve the bug. VER 2.04, BLD 1 - NEW FEATURES + BUG FIXES ------------------------------------------ - Added Output Viewer for Screen option. This new form shows all results in a grid that you can sort, copy, filter, etc. - Fixed bug (thanks Paul Hayward) where query differences were not being properly detected. Had setup the Property Value to Memo size (64k), but a routine inside was still truncating the values at 255 length. Removed this limitation to fix the bug. - Fixed bug (thanks Michael Murfitt) where second MDW security file was not properly accessed. User found this bug *and* the solution--put the code back 3 lines. - Fixed bug (thanks Michael Murfitt) where objects (tables, fields, etc.) with names or property values that contained either a single or double quote would generate an error. Corrected all instances (hopefully!) by replacing occurrences found with either '' or "" in place of ' or " for SQL references. - The wizard dialogs were setup as separate pages within the same form (Access does not support all controls embedded within frames as does VB, so opted for pages). The weakness here is that users who press the tab key to move to the next step will get an ugly UI bug...the screen is caught half on one step, and half on the next step. Fix was to set form property to CurrentPage for the Cycle property of all forms. - Added Save Settings and Load Settings buttons to main wizard. Used to only exist in the menu items, now can be found down there too. - Output screen is resizable, wizard is not. - Fixed minor bug where Comparison Field # of # was always one too high on the left #. - Re-wired Common Dialog Box code using class a friend (Lee Wallen) built. - Replaced Error Log that used tables with one that now used text files. VER 2.03, BLD 1 - BUG FIX ------------------------- - Fixed bug where comparing queries (if any existed in either MDB) would crash with invalid reference error. VER 2.02, BLD 1 - BUG FIX ------------------------- - Fixed bug where users selected No for Password and user-level security, but system still thought a password had been entered. Despite being grayed out, if any security element were entered, then MDBDiff thought that element was selected yes even though selected no. VER 2.01, BLD 1 - BUG FIX ------------------------- - Sure enough, I missed a significant bug caught by a user (Jason Marsh). Turns out that the CheckForDifferences() and the CheckForMissing() functions both had an INSERT INTO SQL string incorrect. They should have used a variable for specifying whether to store values into MDB1 or MDB2. Result was that all differences were found, they were just put into the wrong column for display on the report. - Jason Marsh also had an excellent suggestion which is now included. All Field Types are saved as their text names rather than as their numeric type representations. VER 2.00, BLD 1 - MAJOR UPGRADE ------------------------------- - Now, MDBDiff checks tables, fields, indexes, relations, and queries. Furthermore, all of the relevent properties of each object are checked in addition to whether or not the objects exist in both databases. - Ability to Load and Save all Settings defined on the MDBDiff wizard form. Settings files are simple text files with an extension of .mdf. - Ability to use command line parameters to load and automatically run a Saved Settings file. This replaces the older / ugly Auto Execution Parameter File (could only have one of those whereas can have unlimited Settings files saved to run on a scheduling agent). - Very significant improvement suggested by Christian May (from France): MDW File security can now be handled by MDBDiff. Also, simple database password protection is also handled. - There is now a single report containing all object differences with a side by side comparison of MDB#1 vs. MDB#2 property values. Used to output three reports. - Re-worked Output for Files to output a single query listing all object names, property names, and the values of both databases that differ. Used to output three files. - Removed old countdown screen, and all associated Auto Execution Parameter file garbage. Load and Save Settings new functionality is much better. - Changed icon to two apples (was apple and orange). - Added menu bar with File and Help items. Got rid of toolbar. App has more professional look and feel. - Improved the verification checks on user input before running the comparison. - Renamed all forms and modules with more appropriate prefixes such as LIB_ for library files, APP_ for application specific files, and WIZ_ for Wizard related files. - All previous selections made by user are saved to tbl_properties_local. Then, upon next execution, they are loaded into the form as defaults. - Did standard commenting of code, added error handlers in, re-wrote the help file in HTML since so much changed. - Wrapped all database object comparisons up into a nice single class with a single entry point (CompareDatabases). - Removed extra library code that was unused to make the app smaller. - Handle Database setup and logon errors better. - New Setup Tool. - Built readme.txt and overview.txt files to be included in setup file. - Fixed Help About form to depict copyright changes, where to send money if want to support author, etc.