openaccess/CHANGELOG.md

Change log

Version 1.0.0 - 11 Mar 2015

jwbrookes:

• Added support for Table Data Macros
• Added support for Linked Tables (supports relative paths for linked files)
• Added support for Print Variables in Reports (Page size and orientation)
• Added support for Relation for all types of table
• LoadVCS warnings removed when no object delete is required
• Removed elements from Report export that change constantly but don't affect import
• Fixed query import bug (complex queries being rearranged on import)
• Fixed missing constraints in table export

prmills:

• Added support for bit fields in table Import/Export
• Added support for References without GUIDs
• Export all table data with INCLUDE_TABLES = "*"

Version 0.12.0 - 28 Jan 2015

jwbrookes:

• Refactored AppCodeImportExport into several modules
• Added VCS_Loader, a module to import multiple vba modules into a database

Version 0.11.1 - 14 Jan 2015

jwbrookes:

• Fixed bug in ExportTableDef function
• Removed redundant DeleteFile function (had been left commented out in the module)

Version 0.11 - 01 May 2014

matonb:

• Removed DeleteFile function and replaced calls to Kill with FileSystemObject.DeleteFile

Version 0.10 - 09 Mar 2014

matonb:

• Added DoEvents in loops to avoid "Unresponsive" state.

Version 0.9 - 15 Feb 2014

matonb:

• Aggressive Sanitise, moved BaseInfo from "Block" regex to Line level.
• Changed line level skipping to include lines with deeper indendation the follow. This catches split lines mostly found in BaseInfo exports.

Version 0.8 - 14 Feb 2014

matonb:

• Aggressive Sanitise now excludes "BaseInfo" lines. These lines were seen to be randomly switching between being empty, not present or containing SQL on an arbitary basis.

Version 0.7 - 06 Jul 2013

matonb:

• Replaced TempFile function.
• Temporary file names now generated via external MS libraries.
• Functions using TempFile updated to only call TempFile function once.
  • Temporary file path and name stored in tmepFileName variable.
  • Temporary files deleted when done.
• Changed db declaration in ImportProject to DAO.database.

Version 0.6 - 06 Jul 2013

matonb:

• AppcodeImportExport excluded from ExportAllSource
• Added ImportProject sub-routine,
  Deletes all forms, macros, modules and queries before calling ImportAllSource.
  By clearing out the existing objects, you know that your database only contains
  code from your version control database.
  Excludes AppCodeImportExport

Version 0.5 - 29 May 2013

matonb:

• All "exclusion" patterns are now matched by regex.
• Added StripPublishOption constant.
  If set to True the following lines are also excluded from the export files
  • dbByte "PublishToWeb" ="1"
  • PublishOption =1
• Added DeleteFile(FileName) function
  The function tries to delete FileName three (3) times before giving up.
  A delay of 100ms is introduced between delete attempts should the first fail.

Version 0.4 - 19 Apr 2013

matonb:

• Added dbLongBinary "DOL" to aggressive sanitize, these statements were appearing in queries and being flagged by git as modified in files that hadn't been touched by developers.

Version 0.3.2 - 8 Apr 2013

matonb:

• 0.3.1 Patched - Serious Problem: SanitizeTextFiles If logic removed all lines containing "Begin".
• 0.3.2 Replaced if block for skipping code sections in SanitizeTextFiles with regular expression.

Version 0.3 - 6 Apr 2013

bkidwell:

• Sanitize query exports.
• Fixed SERIOUS TYPO in UCS2-to-UTF-8 conversion (wrong threshold for 2 byte versus 3 byte symbol in output stream).
• AggressiveSanitize default True.

matonb:

• Added AggressiveSanitize constant, it's a number to allow for different levels in the future. Default False.
• Added Skipping for GUID & Namemap in aggressive sanitize mode.
• If AggressiveSanitize is on, also sanitize query exports.
• Append Number of objects imported/exported to information lines in immediate window.
• Updated readme (removed references to terminal window).
• Close all open forms and reports when importing and exporting because you can't import an open form or report.

Version 0.2 - 4 Apr 2013

matonb:

• Added dbLongBinary "DOL" to SkipList in SanitizeTextFiles.
• Added Source directory check to ImportAllSource, pops up a message box if missing.
• Only create source directories if there is something to export.

bkidwell:

• Removed external executable for converting UCS-2-little-endian to and from UTF-8; replaced with VB6 methods.
• Added demo database to the repository.
• Removed the need for a special "export_[name]" query to export and import a lookup table.
• Added check to determine if Queries, Forms, etc. are exported from THIS database (depending on which version of Access created it) uses UCS-2-little-endian, or a legacy 8-bit Windows character set. Skip converting to/from UTF-8 if not using UCS-2, because the point of the conversion was to avoid writing 0x00 bytes in the text files and confuse diff/merge tools.

Version 0.1 - 22 Oct 2012

Initial release