Solved

DataReport creating many tmp files

Posted on 2006-10-21
7
296 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
  • 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

895 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

17 Experts available now in Live!

Get 1:1 Help Now