Relink of SQL Server tables in Access 2013 causes massive bloat

R

remou

Joined
Apr 23, 2014
Messages
1
Reaction score
0
( With reference to pcreview.co.uk/forums/access-2003-relinking-tables-bloat-database-t2253935.htm )

When running the code below to relink SQL Server tables, the database jumped from about 3.5 mb to about 14 mb. Track name autocorrect is turned off.

Code: 
    For Each tdf In CurrentDb.TableDefs
        If Left(tdf.Name, 3) = "dbo" Then
            If tdf.Connect <> scn Then
                tdf.Connect = scn
                tdf.RefreshLink
            End If
        End If
    Next
 
Back
Top