DataReport creating many tmp files

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
LVL 16
suprapto45Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
guidwayConnect With a Mentor Commented:
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
 
suprapto45Author Commented:
>>"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
 
guidwayCommented:
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
suprapto45Author Commented:
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
 
guidwayConnect With a Mentor Commented:
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
 
suprapto45Author Commented:
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
 
guidwayCommented:
Glad a solution was found to the problem. :)
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.