DataReport creating many tmp files

suprapto45
suprapto45 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

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

Commented:
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.

Author

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.
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

Author

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

Commented:
Glad a solution was found to the problem. :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial