Setting Build Properties on the Source Database
Setting properties on the source database is straightforward at this point. We simply need to call the SetDatabaseProperty method for the specified properties. Add the following code to implement the SetSourceProperties method:
private void SetSourceProperties() { // open the source database sourceDatabase = myEngine.OpenDatabase( inputDatabase.Text, false, false, Type.Missing); // set the properties SetDatabaseProperty(sourceDatabase, SRC_PRP_STARTDATE, DAO.DataTypeEnum.dbDate, appStartDate.Value.ToShortDateString()); SetDatabaseProperty(sourceDatabase, SRC_PRP_TARGET, DAO.DataTypeEnum.dbText, outputDatabase.Text); SetDatabaseProperty(sourceDatabase, SRC_PRP_APPMAJOR, DAO.DataTypeEnum.dbLong, appVersion.Text.Split('.')[0]); SetDatabaseProperty(sourceDatabase, SRC_PRP_APPMINOR, DAO.DataTypeEnum.dbLong, appVersion.Text.Split('.')[1]); SetDatabaseProperty(sourceDatabase, SRC_PRP_APPREVISION, DAO.DataTypeEnum.dbLong, appVersion.Text.Split('.')[3]); }
In this tutorial:
- Deployment
- Creating an Automated Build
- Design the Form
- Retrieving Information from the Source Database
- Building the Application
- Creating the Target Database
- Set Build Properties on the Target Database
- Setting Build Properties on the Source Database
- Deleting Data from Tables
- Calculating the Version Number
- Handling Application Dependencies
- Updating References
- Testing Reference Fix-Up
- Late Binding
- Licensing Your Applications
- Number of Records
- Restricting the Number of Times an Application is Launched
- Registering an Application
- Creating a Registration Web Service
- Validate the Registration Using the Web Service
- Miscellaneous Deployment Scenarios
- Create the Client Application
- Testing the Versioning Server
- Re-Linking Tables Automatically
- Programmatically Creating DSNs
- Creating a User DSN
- Ensuring an Application Runs Locally