You are here: start » abeu:start » abeu:tables
Access Back-end Updater Tables
The following tables are used by Access Back-End Updater:
The Updater_Databases Table
Paths, usernames, and passwords to all of your user's back-end databases are stored here. Also stored is the default name of the database and a dialog message for the user when they are prompted to select the database.
To change the name of this table, modify the public constant BEUpdater_Databases_Table_Name and set it to something different.
| Index | Fieldname | Datatype | Description |
|---|---|---|---|
| PK | DatabaseID | Long Autonumber | The databaseID for this database entry |
| DBName | Text(255) | The short filename for this database. (e.g. Orders.mdb) | |
| DBDescription | Text(255) | A Description of this database. (e.g. “The orders database”) | |
| UserName | Text(50) | Default username to use. Can be overridden by setting clsBEUpdater_DB.username property | |
| Password | Text(50) | Default password to use. Can be overridden by setting clsBEUpdater_DB.password property | |
| Path | Memo | The path for this database. This is automatically updated on startup and replaced with whatever is in the .ini file. |
The Updater_Fields Table
This is mainly a junction table used to store the name of a field when used by other commands.
To change the name of this table, modify the public constant BEUpdater_Fields_Table_Name and set it to something different.
| Index | Field Name | Data Type | Description |
|---|---|---|---|
| PK | FieldID | Long Autonumber | |
| FK | CommandID | Long | |
| FieldName | Text(50) | Name of Field |
The Updater_Master Table
The master update table. (See Note 1.)
Fields available include:
| Index | Fieldname | Data type | Description |
|---|---|---|---|
| PK | CommandID | Autonumber Long | The ID of this command |
| FK | DatabaseID | Long | The Database on which to execute this command |
| DataFileVersion | Long | The Data File Version this update command should be executed on | |
| SortOrder | Long | The order in which to execute this command. (See Note 2.) | |
| Action | Integer | An action number that tells ABEU what to do (Create Table, Rename a Field, Execute SQL, etc…) | |
| TableName | Text(255) | The table name on which to execute this command | |
| NewObjectName | Long | New name of the field/table. Only used when a field or table is being renamed. | |
| SQLCommand | Memo | SQL string to execute. Only used when Action Execute SQL. | |
| LinkToCurrentDB | Yes/No | Yes=Also run this command in the CurrentDB or links a created object with the front-end. (See Note 3.) |
NOTE 1: To change the name of this table, modify the public constant BEUpdater_Master_Table_Name and set it to something different.
NOTE 2: The SortOrder column is always sorted secondary to DataFileVersion. (i.e. The sort order will always be DataFileVersion ASC, SortOrder ASC)
NOTE 3: For example, if creating a new table in tblCustomers in database Customers.mdb, you would check this box if you wanted to create a linked table in your current db as well. You can also use this when setting properties.
Actions
Here is the list of the macro verbs performed by the Access Back-end Updater. These actions are used in the Action column of the Updater_Master table:
| Action |
|---|
| Create Table |
| Create Field |
| Rename Table |
| Rename Field |
| Delete Table |
| Delete Field |
| Set Database Property |
| Set Table Property |
| Set Field Property |
| Set Relationship Property* |
| Create Relationship* |
| Delete Relationship* |
| Run SQL Command |
* not yet implemented
The Updater_Properties Table
These are properties to get updated.
To change the name of this table, modify the public constant BEUpdater_Properties_Table_Name and set it to something different.
| Index | Fieldname | Datatype | Description |
|---|---|---|---|
| FK | CommandID | Long | Command ID from Updater_Master. Referenced only when FieldID is blank because we are setting a DB or Table property |
| FK | FieldID | Long | Field ID from Updater_Fields to associate this with |
| PK | PropertyRecID | Long Autonumber | Property's Record ID |
| PropertyName | Text(100) | ||
| PropertyValue | Text(255) | ||
| PropertyType | Text(50) | The type of property this is, e.g. Text, Boolean, etc… |
The ACCESS_BEUPDATER_TEMP Table
This table is used when creating new fields or tables. You should make this something unique that will not ever be used by your application. The default is ACCESS_BEUPDATER_TEMP
To change the name of this table, modify the public constant BEUpdater_TEMP_Table_Name and set it to something different.
Renaming Tables
It is possible to rename these tables. Find the following block of code to rename the tables.
Public Const BEUpdater_TEMP_Table_Name As String = “ACCESS_BEUPDATER_TEMP”
Public Const BEUpdater_Databases_Table_Name As String = “Updater_Databases”
Public Const BEUpdater_Fields_Table_Name As String = “Updater_Fields”
Public Const BEUpdater_Master_Table_Name As String = “Updater_Master”
Public Const BEUpdater_Properties_Table_Name As String = “Updater_Properties”
