Solved

DataReport creating many tmp files

Posted on 2006-10-21
7
303 Views
Last Modified: 2013-12-25
Hi,

I am using DataReport in VB. However, it creates many tmp files in the folder where the DB is located (Access).

Anyone knows what I am doing wrong?

David
0
Comment
Question by:suprapto45
[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
  • 4
  • 3
7 Comments
 
LVL 12

Accepted Solution

by:
guidway earned 500 total points
ID: 17779071
It appears to be the behavior of DataReport. As mentioned in the article the best thing to do is just delete them every so often.
http://www.vbforums.com/showthread.php?t=382479
0
 
LVL 16

Author Comment

by:suprapto45
ID: 17779093
>>"They are only created in development"
How if I have sent them to clients, will the clients be experiencing this kind of behavior?

If so, the clients may not be IT-savvy so I am afraid that they won't delete it till it may be thousand tmp files :(
0
 
LVL 12

Expert Comment

by:guidway
ID: 17780979
By development they may mean it is only created in debug mode, however I am not sure.

My suggestion would be to programmatically check the directory for *.tmp files when your application exits and if any are found, delete them.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 16

Author Comment

by:suprapto45
ID: 17782825
Thanks

>>"My suggestion would be to programmatically check the directory for *.tmp files when your application exits and if any are found, delete them."
However the database may be in other paths and it may not necessarily be in the app folder so I think that I have no choice other than to live with this tmp files.

I will keep this thread open for few more days.

Thanks to both of you.
0
 
LVL 12

Assisted Solution

by:guidway
guidway earned 500 total points
ID: 17784795
how does your application know the location of the database? (ie. environment variable, a relative path in your application, odbc data source path?)

If you could use the same path that the application uses to locate the database then that would solve the problem of knowing where the database is located and deleting the temp files.

hope this helps
guid
0
 
LVL 16

Author Comment

by:suprapto45
ID: 17786497
Hi

>>"how does your application know the location of the database? (ie. environment variable, a relative path in your application, odbc data source path?)"
So here is the flow of my application. Before using my application, user has to create his own DB file from the menu in which he can open / load again later on. So 1 DB file -> 1 specific purpose for one user. This is the problem, he can choose to save the file in any path (depends on the user). I use common dialog to do this.

Perhaps, I will try to create the setup first and see whether tmp files are still created or not

David
0
 
LVL 12

Expert Comment

by:guidway
ID: 17800968
Glad a solution was found to the problem. :)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Visual Studio 2005 text editor 10 55
Macro Excel - Multiple If conditions 2 94
pop out of webbrowser1 control vba6 5 51
Sub or Function is not defined 6 59
Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

739 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