How to Delete TMPCLP files

[byTimber]

Does anyone know how to get rid of the list of files in my database which are labelled <Form_~TMPCLPetc.> ?

They appear when in Code view in the nav pane and don't seem to be required.

Thanks....

 

[PeterF]

Do a compact and repair, they look like deleted forms.
Access keeps the deleted stuf until you do a compact an repair.

 

[byTimber]

PeterF thanks for reply but they are still there after a compact and repair.

Best wishes, Roger ..

 

[niiiiicole]

You get TMPCLP files when there is a broken link. For example, if you create a query based on a table and later on you delete that table but not the query, you will get a TMPCLP file. To know which tables are missing, you can click on Database Tools, Object Dependencies.

 

[arnelgp]

untested.

Public Sub DelTempTable()
Dim t As Dao.Tabledef
Dim db As Dao.Database

Set db=CurrentDb
For Each t In db.TableDefs
If Instr(t.Name,"~") > 0 Then db.TableDefs.Delete t.Name
Next
set db=nothing
End Sub

 

[silentwolf]

untested.

Public Sub DelTempTable()
Dim t As Dao.Tabledef
Dim db As Dao.Database

Set db=CurrentDb
For Each t In db.TableDefs
If Instr(t.Name,"~") > 0 Then db.TableDefs.Delete t.Name
Next
set db=nothing
End Sub

Hey I found this thread but it does not do the trick unfortunatelly .(

Not sure how you can add the link to those two threads..