I usually create multi-file databases. Each file may have many tables that are usually associated to each other. I dont expect this approach to be uncommon. I need a better way of keeping track of which version the file (or database as a whole) is at.
I was thinking of making a table in each file whereas each record contains the version number, at that time, and other info such as date, changes made, etc. of that version.
I'm wondering how others handle it?