8 ms·
For MS Access files there exists a project ([1], last activity in 2018) which basically splits the file into its components (like forms, queries, macros etc.) w
by taffit 6y ago
For MS Access files there exists a project ([1], last activity in 2018) which basically splits the file into its components (like forms, queries, macros etc.) which you can then check into your VCS. This way, single versions of an MS-Access-file are diffable to previous versions and you can track exactly what has been done... in a developer fashioned way, though.
If you would need an exact version, you can build this version out of its components of that version.
[1] https://github.com/timabell/msaccess-vcs-integration/ https://github.com/timabell/msaccess-vcs-integration/
- smitty1e 6y agoThe MS Access Application object has some additional powers, LoadFromText() and SaveToText() not really found elsewhere in Office. However, you can't really used them to dump the current database, and they don't both appear to be used in timabell's work for a quick glance. The loader method even allows for the lighter-weight Forms from the other Office applications to be pulled into Access, though the motive for using them would not be clear. My intent had been to write an Excel macro workbook as a manager tool, and use it to manage Access Dbs in git. I have a library I call "The NecroVisualBasiCon" out in GitHub that I'll share if anyone is interested in peering into an abyss.
- mmerlin 6y agoThe forked version which is an Addin runs about 4x faster, and is actively being developed now https://github.com/joyfullservice/msaccess-vcs-integration https://github.com/joyfullservice/msaccess-vcs-integration