Can I safely delete vba modules starting with form_~TMPnnn and where did they come from?

I have a number of modules in my project that start with form_~TMPnnnnnn or report_~TMPnnnnn.  I think I can safely assume they were at one time temporary but what created them and can I safely delete them?

Thanks
ErinRadAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I would visually look at what is in those modules, then decide.  I would *seem* so ... but .....?

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Never heard or seen anything like that.  This is an ADP project?

I would first BACKUP, then try a compact and repair.  If they really are temp objects, the C&R should get rid of them.

Jim.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
HainKurtSr. System AnalystCommented:
before deleting, try to compact/repair db
they should go away...
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
They could be temp modules installed by a 3rd party addin.  I have a SQL editor that taps into the query grid, as well as in VBA ... and it installs a temp vba module with a similar type of name.

mx
0
 
ErinRadAuthor Commented:
Well, I compacted/repaired and the little devils are still there.  I'll have to do this the old-fashioned way... backup, delete, test, ...  Also interested in the 3rd party add in.  Before going to Office 2010 I used a 3rd party object dependency browser.  Will investigate.  Thanks.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:


"backup, delete, test,"

backup, delete, Compact & Repair (to really delete),  Compile ... errors ?
Also, why not just look at the modules ?

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Before going to Office 2010 I used a 3rd party object dependency browser. >>

 I think mx got it and that's probably it.  Find and Replace (another add-in) leaves some temp tables behind as well.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
" Find and Replace (another add-in) leaves some temp tables behind as well."
Yes, but ... there is an F&R option to put all of that in a separate FR mdb, which actually makes the searches faster - and leaves nothing behind.

This is the SQL Editor - very cool.

http://www.aadconsulting.com/ezysql.html

mx
0
 
ErinRadAuthor Commented:
To DatabaseMX:  I will look at each module before I delete (compact again) & test it just that there are more than a few of them.  

Interestingly, when I right click on the procedure name the menu option for Removing the form of the same name is disabled, but if I select View Object from that same menu it opens the object with the TMP name.
0
 
ErinRadAuthor Commented:
Bingo!  Thanks, DatabaseMX.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.