Relink of SQL Server tables in Access 2013 causes massive bloat


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top