Internal Minor Functions

Public Function EncodePassword(Password As String) As String

Encode the passed password

Public Function ExternalBackEndDbInfoTableLink(DatabaseTypeStr As String, DbFilePath As String, ODBCConnectString As String, ODBCPassword As String, ADOConnectString As String, UseADO As Boolean, Optional SuppressErrorMsg As Boolean = False) As String

Link the framework Back End information table from an external database as the 'test table'

Public Function ExternalFrontEndDbInfoTableLink(DatabaseTypeStr As String, DbFilePath As String, ODBCConnectString As String, ODBCPassword As String, ADOConnectString As String, UseADO As Boolean, Optional SuppressErrorMsg As Boolean = False) As String

Link the framework Front End information table from an external database as the 'test table'

Public Function ExternalTableLink(ExternalTableName As String, DatabaseTypeStr As String, DbFilePath As String, ODBCConnectString As String, ODBCPassword As String, ADOConnectString As String, UseADO As Boolean, Optional SuppressErrorMsg As Boolean = False) As String

Link a table from an external database as the 'test table'

Public Sub ExternalTableUnlink()

Unlink the 'test table'.


Public Function GetDatabaseParam(ParamString As String) As String

Extract the 'DATABASE' section from a connection string, or return the entire connection string if it only has one section.


Public Sub RelinkAccessDbTables(dbs As DAO.Database, DB_ID As Long, DB_Password As String, DB_FilePath As String , Optional AddLocalTablePrefix As Boolean = False , Optional SelectiveLinkSql As String = "")

Relink tables for the specified linker database

Public Function TestDbTableLinks(dbs As DAO.Database, DB_ID As Long, DB_Description As String, DB_FilePath As String, DB_Password As String, Optional AddLocalTablePrefix As Boolean = False, Optional SelectiveLinkSql As String = "") As Boolean

Checks:
- that each linked table listed in the linker configuration has a matching linked table in the database
- that a single table from each linked database successfully returns data

Public Sub WriteToErrorLog(recs As DAO.Recordset, SessionID As String, ErrorCatStr As String, ErrorLocation As String, ErrorText As String, Optional ErrorAddlInfo As String = "")

Write an error to an error log already opened in a recordset.