Version control for VBA file

Question

I have a huge MS Access document with built-in VBA codebase. Is it possible to track the file (as I am developing it) with a (mercurial) version control system? Can I extract code and track that? Or is it just the-binary-file-path? Thanks.

Answer 1

It's possible to version-control binary files, but it would be a little cleaner (IMO) to have the code separate. If it works for you though, then by all means do what you do.

Answer 2

Might want to check out this very similar question.

Answer 3

It's possible with MS Access to export most of the code through scripts. I posted some here a while ago:

http://stackoverflow.com/questions/187506/how-do-you-use-version-control-with-access-development