Project Description
MsBuild task implementation for msaccess files. Mdb,adp or accdb creation from sourcecontrol.
- Make mde
- Compact database


Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<UsingTask TaskName="CreateAccessFromSourceSafe.ImportAccessFromSourceSafe" AssemblyFile="CreateAccessFromSourceSafe.dll"/>

<Target Name="ReleaseBuild" DependsOnTargets="Binplace;Build;" />

<Target Name="Build" DependsOnTargets="BinPlace;CopyMdb">
<CreateAccessFromSourceSafe.ImportAccessFromSourceSafe ImportPath ="$(BuildPath)\Working" OutputPath="$(BuildPath)\yournewmdbfile.mdb" AccesType="mdb" CompileModuleName="vba modulename" ReferencesFileName="$(BuildPath)\references.txt"/>

<Target Name="CopyMdb">
<Exec Command='copy /Y $(BuildPath)\Working\acbfilenamefromyoursourcecontrolledaccessproject.acb $(BuildPath)\yournewmdbfile.mdb'/>
<Exec Command='attrib -r $(BuildPath)yournewmdbfile.mdb'/>
</Target>

<Target Name="Binplace">
<Error Text=" The 'BuildPath' and 'Version' parameters must be set on the command line." Condition=" $(BuildPath) == '' Or $(Version) == '' " />
<Exec Command='rd /S /Q $(BuildPath)\$(Version)' />

<Exec Command='md $(BuildPath)\$(Version)' />

</Target>

</Project>

Last edited Dec 10, 2009 at 12:15 PM by Safi, version 3