• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

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
0
suprapto45
Asked:
suprapto45
  • 4
  • 3
2 Solutions
 
guidwayCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
guidwayCommented:
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

Featured Post

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.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now