CaseyEyring.com Wiki

Access Back-end Updater Tables

Shaun Merrill — 2010-03-23T18:35:40-05:00

@@ -38,9 +38,8 @@
  | |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**. |
- | |Action|Integer| An action number that tells ABEU what to do (Create Table, Rename a Field, Execute SQL, etc...) |
  | | 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.

Access Back-End Updater

Shaun Merrill — 2010-03-21T09:55:55-05:00

@@ -51,15 +51,16 @@
  Next, create a call to [[ABEU:Commands#RunAccessBEUpdater|RunAccessBEUpdater()]] as the first line in your application.  You can do this by creating a Sub Routine called Main() and putting ''Call RunAccessBEUpdater()'' as the first line.  This will ensure that each time your application is launched, Access BE Updater runs to check if it is using the proper data file.
  
  For example, create a module in your front-end database, then create a sub-routine called Main() and add this code to it:
  
-      Public Sub Main()
-           Dim clsBEUpdater as New clsBEUpdater
-           Call RunAccessBEUpdater()
-      End Sub
+   Public Sub Main()
+       With New clsBEUpdater
+           .RunAccessBEUpdater
+       End With
+   End Sub
  
  If you are confused, take a look at the demo.
  
  ==== Links ====
  
    * [[http://www.caseyeyring.com/AccessBEUpdater/|Access BE Updater Home Page]]
    * [[http://bugs.caseyeyring.com/|Bugs & Feature Requests]]

ABEU Forms - created

2010-03-20T19:05:19-05:00

@@ -1 +1,23 @@
+ ====== ABEU Forms ======
  
+ It is necessary to include 3 forms with your application: Updater_Welcome-ConfigAllDBs, Updater_Welcome-ConfigSingleDB, and Updater_ProgressMeter.
+ 
+ ===== Renaming Forms =====
+ 
+ It is not possible to rename forms, however, you may rename the default prefix of "Updater_" to something else.  To do this, open basBEUpdater and find: 
+ 
+      Public Const BEUpdater_Form_Prefixes As String = "Updater_"
+ 
+ Change "Updater_" to whatever you like.  Next, go through all of your forms that are part of the ABEU application and rename the "Updater_" prefix to the new name you set for ''BEUpdater_Form_Prefixes''.
+ 
+ For example, if we change the above line of code to:
+ 
+      Public Const BEUpdater_Form_Prefixes As String = "ABEU_"
+ 
+ we would need to rename each of the ABEU forms from Updater_ to ABEU.  For example, ''Updater_Databases'' becomes ''ABEU_Databases'', ''Updater_DeleteField'' becomes ''ABEU_DeleteField'' and so on.
+ 
+ Note: The ''Updater_ProgressMeter'' form has its own name constant.  To rename this, find the code:
+ 
+      Public Const BEUpdater_ProgressMeterFormName = "Updater_ProgressMeter"
+ 
+ and replace ''Updater_ProgressMeter'' with whatever you rename the form to.  The ''BEUpdater_Form_Prefixes'' has no effect on this form.

Modules used in Access Back-End Updater

2010-03-20T18:41:12-05:00

@@ -3,23 +3,23 @@
  
  ABEU currently requires 5 modules to be packaged with your application.  Below is their descriptions.
  
  
- === basBEUpdater ===
+ ==== basBEUpdater ====
  
  This module contains constants used by ABEU such as dialog boxes, table names, and the path to the INI file that can be redefined by the developer.  It also contains a few functions used by ABEU that should probably be moved into clsBEUpdater.
  
- === basFileDialog ===
+ ==== basFileDialog ====
  
  This is a helper class that contains the file dialog functions.  It is used to allow the customer to select their back-end database(s) prior to an upgrade.
  
- === basINIFunctions ===
+ ==== basINIFunctions ====
  
  This is a helper class that contains the INI functions.  It is used to read/write from the INI file used to keep track of the back-end database locations, usernames, and passwords.
  
- === basStatusMeter ===
+ ==== basStatusMeter ====
  
  This is a helper class that contains the progress bar functions.  It is used to display a status bar to inform the user of the update progress.
  
- === clsBEUpdater ===
+ ==== clsBEUpdater ====
  
  This is the main class required for ABEU to function.

Commands Available to ABEU

Shaun Merrill — 2010-03-20T18:07:42-05:00

@@ -27,9 +27,21 @@
  ==== fDoesTableExist() ====
  Public Function fDoesTableExist(strTableName As String, strFieldName As String) As Boolean
  
  
+ ==== fGetDatabasesListForComboBox() ====
+ Public Function fGetDatabasesListForComboBox(blnIncludeOptionForCurrentDB As Boolean, [strCurrentDBName As String = "   (Current DB)"]) As String
  
+ ==== fGetDataFileVersionsList() ====
+ Public Function fGetDataFileVersionsList() As Integer()
+ 
+ ==== fGetDataFileVersionsListForComboBox() ====
+ Public Function fGetDataFileVersionsListForComboBox() As String
+ 
+ ==== fGetINIPath() ====
+ Private Function fGetINIPath() As String
+ ==== GetDataFileVersions() ====
+ Public Function GetDataFileVersions([intDatabaseID As Integer])
  
  ===== Private Procedures =====
  These are procedures that are only available to the class itself and cannot be called from any other module.