On Sat, 9 Dec 2006 23:38:47 -0000, you wrote: > On Error Resume Next > Do While SQLiteConn.State = slStateClosed > SQLiteConn.Open > Loop
I has been quite some time since I wrote VB, but I'll give it a try. You seem to assume that SQLiteConn.Open raises an error when it fails. If it doesn't raise an VBerror, you don't detect something is wrong. SQLiteConn.State will not equal slStateClosed but the error status, so the loops ends and you stop trying to open, without having opened the database. HTH -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------