SQL CE access problem

[Linda]

I would like to ask if there is a way to access the CE DB
table at concurrent time using 2 different command object
to update table through the same connection. ie. 1
command object created and ran in UI thread, 1 command
object created and ran in worker thread.

 

[William Ryan]

I'm 99% sure you can't if one of the command's is still
open.

If you try to connect the Query Analyzer for instance is
open, you can't. I'm pretty sure the same is true for
ADO.NET connections. You can alway test beforehand, ie
if cn.state = ConnectionState.Open then cn.Close();

then reopen it..