Form _~tmpCLP...

[Michael Cochran]

Everyone,

In the view code section of my form, I'm running across a set of code with
the file name form_~TMPCLP619141. I am assuming it is is a temp file left
over from some event. Is there any way to get rid of it?

thanks,

MikeCJ

 

[Allen Browne]

Compact the database.

In Access 2007: Office Button | Manage | Compact/Repair.
In previous versions: Tools | Database Utilities | Compact/Repair.


--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Michael Cochran]

Dear Allen,

I already tried that. Any other thoughts?

MikeCJ

 

[David W. Fenton]

Compact the database.

Doesn't always work, and I don't know why. I recently encountered a
front end (*not* developed by me!) with 4 of these CLP forms and 1
CLP report that had compile issues in the code modules. The
forms/report for these modules no longer existed and I couldn't
delete them and a decompile/compact cycle would not remove them. In
order to get the thing to compile, I had to delete all the code and
save the modules.

It might be that if you create a form and save it with the CLP name
and then delete it, it will get rid of the junk.

 

[Allen Browne]

If it does not delete after a compact:

- turn off Name AutoCorrect
- decompile
- compact again
- create a new (blank) database,
- turn off Name AutoCorrect in the new db,
- import everything (else) from the old database,
- set up the minimal references
- compile.

If you need details of any of those processes for your version of Access,
this might help:
http://allenbrowne.com/recover.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message