tabledefs beginning with "~tmp"

[ajetrumpet]

I know I could test this, but I'm just phishing for information here.

Can someone please tell me how long these deleted tables stay in the collection before they are completely discarded? I am trying to run some test functions through the system tables, and I'm getting quite annoyed with these things. I assume they will disappear if I close the database, or maybe just compact it? That would make sense. I am just tired of writing blocks of code around temporary object names!

 

[Guus2005]

Probably until you compact your database. Use the system tables if you know what you are doing. When you know what you are doing, you should appreciate those ~tmp entries. They allow you to undelete deleted objects!

 

[Moniker]

If they bug you that much, just delete them manually from the immediate window.

1. Open the immediate window (press Ctrl-G).
2. Type DoCmd.DeleteObject acTable, "~tmp_whatever_it_is_here"

Rinse and repeat as necessary until they are gone.

 

[ajetrumpet]

thank you guys. Got the info.