Hello, I'm creating a client application in .Net and I am leaning towards the idea of keeping the database open for the life of the program as opposed to closing it after every transaction or group of statements. What I wanted to know was could the database be corrupted if the program was shutdown improperly while the database was open, especially on old versions of windows, like 95/98? andrew
Your database is reasonably guaranteed to be un-corrupted as long as you use the "PRAGMA default_synchronous = FULL; (2)" and you use transactions around activity that is logically atomic. -- Darren Duncan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]