Skip to content

Module: basRelink

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

Dependencies

Module Dependencies: - fso - ws - DBEngine - db

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

Procedures

RelinkODBC

Type: Public Function
Lines: 153
Returns: Boolean

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

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

Update_zstblODBC

Type: Public Function
Lines: 70
Returns: Boolean

Calls: strConnectArray, strSubArray, OpenRecordset, Update_zstblODBC, CurrentDb

Complexity Notes: - ⚠️ Contains GoTo statements

RelinkTablesLocal

Type: Public Function
Lines: 75
Returns: Boolean

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

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: Fields, PopulateTableList

Complexity Notes: - ⚠️ Contains GoTo statements