MS Access project in TFS assembly
I have a question for all of you and please, any ideas are appreciated. We have many MSAccess database projects in our repository where developers work and test in Dev Envoirment there. As you all know, compiling a database project in itself is a wrong statement, so you really need to check your scripts and reports and everything else in the database again. So what can we do in TFS build script in case of MSAccess projects I have no idea. Anyone who ran into this problem and did something about it, I would say if you share.
Any example or link that explains how to do this would be even better. Please understand that his projects are accessing MS.
Thanks BOB
Compilation is not a completely wrong instruction.
On the VBA side, there is an option in the Debug menu called Compile (I don’t believe this is actually a compilation like in C, but this is a preliminary analysis of your code, etc.). This, combined with the creation of MDE in the GUI side, equates to compilation.
As a rule, when working with VBA, I often run compilation to make sure everything is syntactically correct, etc.
As far as testing goes, once you know what it is compiling you are still not done. If it is possible to compile and still be wrong. This is why you need automated test scripts. I would consider a small script / form in the MDB that you can manually run to open and close all reports that touch and implement the code. The actual functionality of the form would be more complex to automate, but it could also be done.
source to share