Skip to content

Module: basRelink

Type: Standard
Lines of Code: 604
Source: ms_access_files\amber\Modules\basRelink.bas

Dependencies

Module Dependencies: - db - fso - ws - DBEngine

Tables Accessed: - End - Next - Else - zstblODBC - zstblODBC_tables - SQL - Access

Procedures

RelinkODBC

Type: Public Function
Lines: 153
Returns: Boolean

Calls: TableDefs, Erl, RelinkODBC, CurrentDb, DCount, OpenRecordset

Complexity Notes: - ⚠️ Contains GoTo statements - ⚠️ High branching (7 If statements) - ⚠️ Large procedure (153 lines)

Update_zstblODBC

Type: Public Function
Lines: 70
Returns: Boolean

Calls: Update_zstblODBC, strSubArray, CurrentDb, strConnectArray, OpenRecordset

Complexity Notes: - ⚠️ Contains GoTo statements

RelinkTablesLocal

Type: Public Function
Lines: 75
Returns: Boolean

Calls: CurrentDb, RelinkTablesLocal, Workspaces, TableDefs

Complexity Notes: - ⚠️ Contains GoTo statements

CompactTablesMain

Type: Public Function
Lines: 19
Returns: Boolean

Calls: CompactTablesMain

Complexity Notes: - ⚠️ Contains GoTo statements

CompactTablesLocal

Type: Public Function
Lines: 56
Returns: Boolean

Calls: CompactTablesLocal, Workspaces

Complexity Notes: - ⚠️ Contains GoTo statements

TableExists

Type: Public Function
Lines: 20
Parameters: ByVal pstrTableName As String
Returns: Boolean

Calls: CurrentDb, TableExists, TableDefs

Complexity Notes: - ⚠️ Uses On Error Resume Next

PopulateTableList

Type: Public Sub
Lines: 36

Calls: PopulateTableList, Fields

Complexity Notes: - ⚠️ Contains GoTo statements