Why the exception "Could not save; currently locked by another user" raise?
-
When i tried to update the contents of a table in my database using oledbcommand i am getting the "Could not save; currently locked by another user" exception. I tried closing the connection other places where ever it is used. But still the same problem is coming? what should i do? Please help me?
-
When i tried to update the contents of a table in my database using oledbcommand i am getting the "Could not save; currently locked by another user" exception. I tried closing the connection other places where ever it is used. But still the same problem is coming? what should i do? Please help me?
I assume this is an access db ? How many connections does your code have ? Why does it have more than one ?
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
When i tried to update the contents of a table in my database using oledbcommand i am getting the "Could not save; currently locked by another user" exception. I tried closing the connection other places where ever it is used. But still the same problem is coming? what should i do? Please help me?
If u r the only one using that db than surely there's a place left in your code where db connection left open.
-
I assume this is an access db ? How many connections does your code have ? Why does it have more than one ?
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
Thanks for the reply, Exactly i am using access. Actually my code calls internally some services which are also using the same connection and upto my knowledge they are getting closed as soon as the service use is finished. Or otherwise is there any way to view all the connections which are open?