I have a tabbed form with subforms which in-turn have subforms. I am able to load the data in the fields the way i want to through queries and ADO code. On adding data in the form, it updates 3 tables. In 1 table it is done automatically thru' the access connection between tables and forms whiile in the other tables, the updates in the tables is done through ADO code using the after update event. I am able to add/update the data in these other tables without any problem. The problem comes when i try to delete an existing record from the form. When i try to delete a record it gives me the following message:
"microsoft jet database engine stopped the process because you and other user are attempting to change the same data"
Inspite of this, the ADO code updates the 2 tables it is suppose to while the table in direct connection with the form doesn't delete the entry and gives the above mentioned message. For now i have disable the delete and have to do it manually so that the inventory it controls doesn't get messed up. Could someone please let me know a possible solution.
Rishi.
"microsoft jet database engine stopped the process because you and other user are attempting to change the same data"
Inspite of this, the ADO code updates the 2 tables it is suppose to while the table in direct connection with the form doesn't delete the entry and gives the above mentioned message. For now i have disable the delete and have to do it manually so that the inventory it controls doesn't get messed up. Could someone please let me know a possible solution.
Rishi.