Skip to content

Module: basRelink

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

Dependencies

Module Dependencies: - fso - DBEngine - ws - db

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

Procedures

RelinkODBC

Type: Public Function
Lines: 153
Returns: Boolean

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

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

Update_zstblODBC

Type: Public Function
Lines: 70
Returns: Boolean

Calls: strSubArray, OpenRecordset, CurrentDb, strConnectArray, Update_zstblODBC

Complexity Notes: - ⚠️ Contains GoTo statements

RelinkTablesLocal

Type: Public Function
Lines: 75
Returns: Boolean

Calls: CurrentDb, TableDefs, Workspaces, RelinkTablesLocal

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: Workspaces, CompactTablesLocal

Complexity Notes: - ⚠️ Contains GoTo statements

TableExists

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

Calls: TableExists, TableDefs, CurrentDb

Complexity Notes: - ⚠️ Uses On Error Resume Next

PopulateTableList

Type: Public Sub
Lines: 36

Calls: Fields, PopulateTableList

Complexity Notes: - ⚠️ Contains GoTo statements