Error in updating records
Posted on 2001-06-22
Below is my problem nature:
I have a database table located at network(Microsoft Access format)which i need to update it frequently, before i do the updating process i must extrac the same group of data to get certain info from it and then update the selected records accordingly.
My problem now is that when i perform the updating process too frequently(using loop), i found out that the previous updating process is not complete yet,and i can't select the correct amount of records to do the next update process... Is that anyway that can let me do the detection to prevent this kind of problem?
My Problem's Detail:
- I'm using ADO and DSN in communicate and connecting my access database located in network. In the same time i m using a datagrid control that let the user input their data and see the change.
- I'm sure that my code logic can work finelly because when i debug the code step by step using F8, all my records are update correcttly.Actually just few particular field can't be update correcttly during my program normal execution.
-When i using the DataGrid Control in acceptting and showing the output, i hit a problem that the data will automatic store into the correspone table, which i don't want it to happend, i only want the data to be saved when the user click on the Save button. This problem continue to occur even i already uncheck the AllowUpdate property in the DataGrid control, can anyone provide me a solution for this?