Solved

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

Posted on 2011-09-27
11
229 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
  • 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 57
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 51

Expert Comment

by:HainKurt
ID: 36712317
before deleting, try to compact/repair db
they should go away...
0
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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 57
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 - Access MVP) 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now