Hi Dennis Thanks for your answer. You have see my problem and its solution. I look sometimes at SQLite with my "OLE-DB"-Eyes. In OLE-DB is the Recordset Reader and Writer allways at the same time.
Now I consider this... and it works fine. Greetings, Anne > I think you are saying you have an active select statement (i.e. a > reader) in progress and then you are trying to do a delete to remove the > current record. The delete would need to write to the database table. > > SQLite can support multiple simultaneous readers, or a single writer, > but not a mixture of active readers and a writer. When a reader is > active it holds a shared lock on the database. When a writer starts, it > tries to get an exclusive lock on the database. If there are any active > readers the writer can't get the exclusive lock. > > You must close the reader (i.e. finalize or reset the select statement) > before the delete can be done. > > HTH > Dennis Cote > -- Mobile Internet - E-Mail und Internet immer und überall! GMX zum Mitnehmen: http://www.gmx.net/de/go/pocketweb
