Windows Explorer lets you open archive (tar and tgz) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
I am not a database expert nor am I conversant with database design, but I have had a couple of run-ins with databases that are either badly designed or use a platform that doesn’t meet the needs of the end-user. I would like to think this is a "le…