Q: I created an Access Database and added it to my source code control repository using Ivercy. Now I want to create a local Database from the repository using the Microsoft Source Code Control Add-In, but I get the error "Failed to create a new database based on a SourceSafe project." and the local Database is not created.
A:
The Microsoft Access Source Code Control Add-In needs the additional file YourDatabaseName.ACX to
create the local Access Database from the source code control repository. Ivercy does not create this file
because it does not need it.
You can create this file in any text editor and add it manually to the folder in your repository that contains the files for your Access Database using your source code control client application.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<SCCProperties xmlns="http://schemas.microsoft.com/office/access/2006/01/sccproperties">
<DBVersionToCreate>sccFileFormatAccess2010</DBVersionToCreate>
</SCCProperties>
The highlighted text needs to be adapted to your database type. Insert the following corresponding to your file type:
sccFileFormatAccess2010
sccFileFormatAccessADP2010
sccFileFormatAccessMDB2010After adding this file to your repository folder, you can create the local database with the Microsoft Access Source Code Control Add-In.