I have some code that drops all of the linked tables but I do not know how to alter it to only drop linked dbf tables while still maintaining a link to all of my back end access tables.
For Each tDef In CurrentDb.TableDefs
If CBool(Len(tDef.Connect)) Then
Debug.Print "Dropping linked Table: "; tDef.Name
CurrentDb.Execute "DROP TABLE [" & tDef.Name & "]"