错误:-您无法打开表"Table_Name"进行修改. [英] Error:-You Can't Open the table 'Table_Name' for modification.

问题描述

大家好，

我在表单加载时遇到了一个关键问题``您无法打开表Table_Name进行修改''.其中有一条alter语句会引发错误.帮助.
Microsoft Access 2000和vb6连接性

问题的详细信息:-
我创建了``X''表的记录集``rs1''，并创建了一个克隆记录集``rsClone''.并使用rs1记录集设置了Hirerchical Flex网格.
现在，我使用的是"rsClone"的recorset筛选器选项，这时Flex Grid绑定了"rsClone"记录集，并根据过滤条件给出了结果.现在我使用close关闭并销毁了记录集并将其设置为nothing.everything一切正常，但再次当窗体进入其load事件时，它将引发错误
``您无法打开表Table_Name进行修改''，并且第二次打开表单以及进入表单加载事件时将出现此错误.第二次是指我第一次打开并运行vb项目时仅如果我关闭该项目并再次运行，它将运行良好，但稍后会出现问题.我知道该错误，但我不知道为什么在关闭并销毁记录集后绑定仍然存在

请有人帮忙会很高兴.

谢谢
Sukhen Dass

Hi All,

I m facing a critical problem ''You Can not Open the table Table_Name for modification'' on form load.There is one alter statement in which error throws.I googled and trying to resolve this problem but not satisfactory result and I want expert developers help.
Microsoft access 2000 and vb6 connectivity

Details of the Problem:-
I have created a recordset ''rs1'' of ''X'' table and I created a clone recordset ''rsClone''.and set a Hirerchical Flex grid with rs1 recordset.
Now,I am using the recorset filter option of ''rsClone'' and at this time Flex Grid binds with the ''rsClone'' recordset and according to the filter condition it gives the result.now I closed and destroyed the recordset using close and setting it to nothing.everything is working fine but again when the forms come to its load event it throws an error
''You Can not Open the table Table_Name for modification'' and this error comes when second time I open the form and when it goes to the forms load event.Second time means When I first time open and run the vb project then only and if i close the project and run again first time it will work fine but later it gives the problem.I know about the error but I dont know why the binding still exist after closing and destroying the recordset

Pls if any body could help would be glad.

Thanks
Sukhen Dass

推荐答案

直到您手动将表结构和数据从原始Access DB导出到新的Access DB之前，该错误都无法得到解决.
我遇到了同样的问题，并使用上面解释的技术解决了同样的问题.

This error is not get resolved until and unless you manually export table structure and data from original access DB to new Access DB.

I faced the same problem and resolve the same using technique what i explain above.

这篇关于错误:-您无法打开表"Table_Name"进行修改.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！