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
 

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

Similar Threads

SQL Server linked tables 1
Conecting Access to SQL in Windows 7 4
Relink To Backend DB that Protected 1
Relink question 29
link all tables but one using VBA 1
Could Not Find Installable ISAM 2
Update/Refresh of linked SQL ODBC .Connect string bloats Database 1
Reconnecting Linked tables to SQL Server 2

Top