Version control for Microsoft Access development?

Question

We recently saw this post:

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

We then wrote a .vbs script from the example in that post to decompose a .mdb MS Access file.

Problem is, when I run the script against the .mdb file, i get an error:

decompose.vbs(71, 5) (null): Microsoft Office Access can't open the database because it is missing, or opened exclusively by another user.

Well, it's not missing and it's not opened by another user. And there's no lock file associated with it.

Any idea what's going wrong?

Or is there an easier decompose our Access database for use in our versioning software?

Thanks Much!

Doug Dexter

Answer 1

Access 2007 allows you to easily integrate with Visual SourceSafe if you have the Access 2007 Developer Tools and Visual SourceSafe:

http://office.microsoft.com/en-us/access/HA102092361033.aspx

Answer 2

Ok.

My boss found this: http://www.accessmvp.com/Arvin/DocDatabase.txt

And it works..

we added a new macro to the Access app and ran the new macro.

BOOM.

Everything written out to our directory.

So