Well, I posted an entry explaining this yesterday but it seems to have disappeared. Not sure what happened there. I was having a few problems accessing the site yesterday. I can't be bothered writing it all again, but basically you cannot compact a database while it is open. If you want to run the compact from code, you must run it from a different database. Then you can use DBEngine.CompactDatabase, making sure that the data file is closed and is not in use before you do the compact.

Try this SELECT cases, ID FROM TAbleB b Join TableA a on a.release = b.release and check your indices Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Hi vica dianto, This Query also takng much time.. but much faster than what i posted. I want to insert these result in an access table also. Is the insertion creating the touble or the query itself? Hi abcurl, "Status = 'PASS'".. Status can be fail or pass, but if two similar Cases having different status I want the lastest status, ie Case having Laresgt ID. One more thing i want the result to be inserted in an access table also Thanks alot for the replies Jishith

If it succeeds, no exception will be thrown, and File.Exists(destination) will return true

Check this article out ... http://msdn.microsoft.com/en-us/library/tchktcdk(VS.80).aspx[^]

This forum holds all about MySQL which is different from SQL Server, Access and many others handled in the Database forum. :) Luc Pattyn [Forum Guidelines] [My Articles] - before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Look into database transactions. I recommend this site as a starting point

Then you're going to have to put some tracing code in there to see what variables have what values at various points in your code. Log this information to a file and review it when the problem occurs. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

ComboBox.RowSource = "" Check out the CodeProject forum Guidelines[^]

Thanks for the reply.

The article mentioned in previous reply is perfect call for this situation. But, Now .NET supports recursive search by using simple code snippet. Have a look in following code snippet : Dim myFiles() As String = Directory.GetFiles("C:\Temp", "*.*", SearchOption.AllDirectories) If myFiles.Length > 0 Then 'Do process list of files retrieved End If dnpro "Very bad programmer"

Thanks eddy, i resolved the error...

Directory.GetFiles, from memory, then for each file, you would have to request the fileinfo to get the modified date. Christian Graus Driven to the arms of OSX by Vista.

You need a table/list of filenames with a datetime field. Start loop (foreach file in directory) check if the file is in the list add the file to the list with the time (first pass) if the file is there has enough time passed (check time flag in list for this file) if time passed > Setting then process end loop A potentially locked file has been in the folder less than #n seconds/minutes. You really don't care if it is actually locked, just make sure the time to wait is > than any possible locking period. Never underestimate the power of human stupidity RAH

jishbalan wrote: But these won't work , if the folder is across network. Getting "permission denied" error.. Did you read the documentation on the FileSystemObject?? If not, I highly suggest doing so. You got the permission denied error either because you don't have write/create permissions in the target directory, or the target directory files/folders are ReadOnly and you're trying to overwrite them. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Hi, If you are going to write any code that manipulates files or folders then you need to become familiar with the classes in the System.IO namespace. There aren't many and it won't take you long to browse through the documentation and get an idea of what they do. In answer to your specific question about folder update time take at look at either System.IO.Directory or System.IO.DirectoryInfo and you will find the answer. Alan.

eddyvluggen wrote: create a list of the files and their dates. Save the list to disk, and compare it to the directory-structure when your application starts Or use WMI permanent event subscription[^] In January you said "Money in April" - That was two years ago! B. Python