Error:-You Can't Open the table 'Table_Name' for modification.

See more:

VB6

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