Using Vault with a Microsoft Access application

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
bboppel
Posts: 6
Joined: Sun Jan 27, 2013 6:20 am

Using Vault with a Microsoft Access application

Post by bboppel » Tue Sep 15, 2015 6:43 am

Has anyone implemented version control with a Microsoft Access application? My goal would to be able to check out/in various Access objects (forms, queries, tables, reports, and vba modules). If that is possible and feasible, then my next goal would to be able to deploy "checked-in" changes to a "production" copy of the Access mdb file.

Thanks in advance!

Tonya
Posts: 866
Joined: Thu Jan 20, 2005 1:47 pm
Location: SourceGear

Re: Using Vault with a Microsoft Access application

Post by Tonya » Tue Sep 15, 2015 7:54 am

Vault doesn't support integration with MS Access. But you can use the Vault GUI Client to perform version control features. Any file type that can be stored in SQL Server is supported.

Let me know if you have any additional questions.

Thanks!

PhilS
Posts: 24
Joined: Wed Sep 16, 2015 12:23 pm
Location: Germany
Contact:

Re: Using Vault with a Microsoft Access application

Post by PhilS » Wed Sep 16, 2015 1:09 pm

If you want to use version control from with the Microsoft Access development environment, you’ve got three options.

1.) Use the LoadFromText/SaveAsText-Methods of the Access.Application-Object to import/export all the Access objects as text files to the file system and the use the Vault Client (GUI or commandline) to manage them in Vault.
Of course you can automate the import/export part using VBA.

2.) Up until Access 2010 Microsoft offered an free add-in that integrates and interface to version control software into Access. This add-in allows to use version control commands from within the Microsoft Access development environment. It works well with Vault. I used it for many years. Download it here from the MS Download center.
Unfortunately MS discontinued this add-in with Access 2013.

3.) Because I depend heavily on version control integration into Microsoft Access, I needed a replacement for the Microsoft add-in for Access 2013 onward.
So I built such an add-in myself. As we use Vault for version control with our projects, Vault will be very well supported by our Access Add-In.
It is going to be a commercial product and the public release will be in September 2015. You can have a look at the website for the version control add-in for further information.

@ForumModerators: I apologize, if you consider mentioning my own product inappropriate here. In that case, feel free to delete paragraph 3, but please leave the rest of the answer. This information is not known very widely.

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Using Vault with a Microsoft Access application

Post by Beth » Thu Sep 17, 2015 9:02 am

PhilS: Thank you for your contribution.

bboppel: I know there were some people in the past who made it work with Access, but I don't know the details of how they made it work. Like Tonya said, we don't support it. All I could suggest is to run some Google searches.
Beth Kieler
SourceGear Technical Support

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Re: Using Vault with a Microsoft Access application

Post by jclausius » Thu Sep 17, 2015 9:07 am

PhilS, No problem.

I'll also pass this along to our sales team as they get the occasional question regarding Vault integration with Access. It will be good to let others know there are third-party solutions available.

Thank you for your post.
Jeff Clausius
SourceGear

Post Reply