BTAB Development Backend Auto Updater
IMPORTANT: When you open the file, you need to HOLD the SHIFT key down so that it doesn’t try to run and do an update on a non-existing database.
Description: How to use the BTAB Development Backend Auto Updater.
Process:
1. The Backend Auto Updater is a tool which will allow you to automatically update a backend database (or actually any mdb file), if a table has to be added, deleted, or column added or deleted. It will not merge data.
.
2. The update information is kept in the table su_tblActions
3. The table has five fields to fill out.
a. TableName – This is the table that is to be updated, either fully replaced, deleted, or a column added or deleted.
b. UAction - This is the action that you are wanting. The valid choices you can enter are: Replace Table, Drop Table, Add Column, or Drop Column.
c. UColumn – This is the name of the column affected. Leave it blank for Replace Table, Drop Table, or Add Table.
d. UDatatype – This is the data type of the column you are adding. Leave blank if you are not adding a column.
You can use TEXT, DATE, MEMO, SINGLE, DOUBLE, INTEGER, LONG INTEGER, etc.
e. ULength – This is the column length. Use this only for Text or Binary data types.
4. .Open the table “su_tblBackendPath” and put in the path to the database you are going to update.
5. Once you have filled out the table, import any tables you are going to be adding or replacing
6. Once you have imported the tables, the updater should then be ready to distribute. All the user has to do is open the updater and it will run and do all of the tasks that are in the su_tblActions table.
Page 1 of 1