Deleting ~TMPCLP

[Thompyt]

I have ~TMPCLP files in my VBA App. I don't know where they came from or what they do and they seem like extra. I would like to delete these. How do I go about it?

[Perceptus]

Run a compact and repair. See if that helps. I think this flushes out that temp info.

also
http://www.access-programmers.co.uk/forums/showthread.php?t=237902

[Thompyt]

It doesn't work, I already tried that one.


I'll work on this, dowsn't seem to work as yet.

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
Thanks

[orange]

They are not tables according to your jpg. They appear to be reports??
I am surprised they were not removed via Compact and Repair.
Often any object beginning ~ is a "deleted" version of something and would be purged with C&R.

Can you go to design view or report view?

[ohmydatabase]

In the Immediate Window, I executed:

DoCmd.DeleteObject acForm, "~TMPCLP385211"

I did this manually for each instance of these TMPCLP Forms.

Before discovering this, I backed up, repaired/compact, decompile, recompile. (The Works) To no avail...