Version Control of Access systems
Posted on 2006-10-31
I'm trying to find a method of assigning version numbers to .mdb files, along the lines of the File Version property of .exe and .dll files; it needs to be accessible (and updatable) programmatically using VBA and/or VBScript, and preferably capable of holding a 4-component version number such as 220.127.116.11. It needs to be manageable externally (for example via a VBScript file), so I don't think the use of a table within the .mdb, or code within the Access app, would be appropriate.
I've seen a "Revision Number" in the Properties -> Summary -> Advanced screen of any file I look at (including mdb's); is this a possibility that might be appropriate in these circumstances? If so, how do I access and update it? Some specific code examples would be helpful ...
Alternatively, if the Revision Number is not suitable, can anybody suggest other techniques for Version Control on .mdb files?