Windows Service中的MS Access2007 [英] MS Access2007 in Windows Service

问题描述

我的Windows服务每5分钟运行一次，以将数据插入到MS Access2007数据库中.记录第一次被完美插入.
对于下一个时间间隔(至少发生5次错误)，它会抛出诸如无法更新，当前已锁定"之类的错误.
我正在为此使用事务.我正在关闭连接并处理转录.我正在照顾所有必要的东西.
但是我不知道为什么会这样.
请指导我.
我是VS 2008，C#.
在此先谢谢您.

Hi,
My windows service is running for every 5 mins to insert the data in to MS Access2007 databse. For the first time records are getting inserted perfectly.
For the next time interval (afetr 5 mis) it si throwing error like "Could not updated, currently loked".
I''m using transaction for this. I''m doing closing the connection and disposing the trancation. All the necessary things i''m taking care.
But I don''t know why it is happening.
Please guide me.
I''m uisng VS 2008, C#.
Thanks in advance.

推荐答案

您可以发布一些代码吗?

好的，显然，我必须在这里继续输入内容，否则这个愚蠢的程序将不允许我提交答案，这不是答案，只是对更多信息的要求，但它不会我不允许发布它，因为它太短了，所以我输入了所有这些废话，因为除非我包括所有这些废话，否则它不会让我提交.

我确实需要查看代码. 10分钟后，没有任何固有变化.这必须是代码中的内容.另外，如果您可以发布实际显示的错误消息，那将非常有帮助.

Can you post some code?

Ok, apparently, I have to keep typing something in here or this stupid program won''t allow me to submit my answer, which isn''t an answer, it''s just a request for more information, but it won''t allow me to post it because it''s too short so I''m typing all this crap because it won''t let me submit unless I include all this crap.

I really do need to see the code. There''s nothing that inherently changes after 10 minutes. This has to be something in the code. Also, if you can post the actual error message being displayed, that would be very helpful.

这篇关于Windows Service中的MS Access2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！