Access 2007 Visual Basic Code Subversioning

Question

Is there a way to version the VBA modules inside an Access 2007 database, or am I just stuck with exporting the code and keeping it separate from the database and maintaining two different copies?

Answer 1

Based on the response so far, I conclude you can't have versioning.

I believe this is because an Access DB code-base is not viewed as a set of modules -- that is, not as interchangeable elements the way code is in many other settings. A truly modular approach increases the requirement for strict control because you must ensure coherence; thus, versioning.

Code in VBA is not handled as agile -- which of course is understandable historically. It's a huge watershed in development approach. So while you benefit from an agile mindset, you won't find it facilitated so well.

NOTE:

In case you're not aware, some key aspects of modular approach are met by separating the app into client and server documents (splitting your database).