No. Any commands will have finished before the user can get to the screen that allows them to move the data files.
Ray Andrews -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of J Decker Sent: Thursday, March 05, 2015 3:45 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] db File Remains Open After Connection is Closed do you have any ... SqliteCommand's laying around that aren't finished? On Thu, Mar 5, 2015 at 12:34 PM, RNACS - Info <info at rnacs.com> wrote: > I have a program written in Visual Basic .NET. > > One of the functions of the program is to move all of the program's > data, including a SQLite database to a different folder. > > The program is a 32-bit application using System.Data.SQLite.dll. > > I am having a problem that after I copy the data to the new folder, > the program fails when I try to delete the old folder. The error > message says that the folder cannot be deleted because the SQLite > database file is in use by another process. > > The code I am using is: > > ' Close license database connection > If Not IsNothing(SQLconn) Then > If SQLconn.State <> ConnectionState.Closed Then > SQLconn.Close() > End If > SQLconn = Nothing > End If > > ' Move data files > '\\\\\ code to move files goes here > > ' Delete old directory > Directory.Delete(strOldLocation, > FileIO.DeleteDirectoryOption.DeleteAllContents) > > The error occurs when I try to execute the "Directory.Delete" statement. > > "SQLconn" is a SQLiteConnection to my database file. Once the > connection is closed & disposed of, what still has the .db file still > open? How do I close the file so I can delete it? > > Thank you for any assistance. > > Ray Andrews > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
