LInked tabled refreshed growing mdb file

[PATRICK]

I have tables from MySQL linked in my front end. Before all the tables was linked by ODBC and now I am refreshing the link because I don't want to create the ODBC on every machine client, but now every time I run the application I call the string for MySQL connection and relink but it started grow my mdb file. Is there anything I can do about ? the code im using is: Dim tdf As DAO.TableDef
Dim tblname As String
For Each tdf In CurrentDb.TableDefs


If Len(tdf.Connect) > 0 Then
tblname = tdf.NAME
DoCmd.Echo True, "Relinking Table " & tblname
tdf.Connect = "STRINGCONNECTION" & dbname
tdf.RefreshLink
End If
Next tdf

[rpeare]

no, there isn't. But as side note, your database will get bloated over time regardless of what you do. It's a shortcoming of MS Access. You will have to regularly compact/repair the front end of your database. MS Access 2007 and up also have the option to "Compact on Close" for each individual database which you might want to consider enacting so you don't have to put any other effort into maintaining your db.