Solved

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

Posted on 2011-09-27
11
274 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:ErinRad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 75
ID: 36712254
I would visually look at what is in those modules, then decide.  I would *seem* so ... but .....?

mx
0
 
LVL 58
ID: 36712311
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
 
LVL 55

Expert Comment

by:Huseyin KAHRAMAN
ID: 36712317
before deleting, try to compact/repair db
they should go away...
0
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
LVL 75
ID: 36712355
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
 

Author Comment

by:ErinRad
ID: 36712449
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
 
LVL 75
ID: 36712504


"backup, delete, test,"

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

mx
0
 
LVL 58
ID: 36712573
<<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
 
LVL 75
ID: 36712634
" 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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 50 total points
ID: 36712663
0
 

Author Comment

by:ErinRad
ID: 36712674
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
 

Author Closing Comment

by:ErinRad
ID: 36712889
Bingo!  Thanks, DatabaseMX.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question