I want to open another thread for the same problem I reported earlier, which remains unresolved. The issue I am now faced with is unless I am able to get this problem solved, my application is unusable. So the 150 or so hours I will have spent on the application will be totally wasted effort and I will never again be able to put A5 forward as solid commercial solution.
The problem I have is I get an error whenever I try to update a record in table. The error is "Record locked by another session or user".
I have tried everything possible to get rid of this problem including packing the database and re-indexing all tables. I have tried re-booting, facing Mecca and even holding my breath in a wind change. Nothing works.
I originally thought the problem had been caused by my PC locking up (Windows XP). But this is not the case as several earlier backups of my database display exactly the same problem.
The problem is easily reproduced in the attached TESTIT database. It's compressed in Zip format.
I have pruned my TESTIT database down to the essentials needed to demonstrate the problem: 5 tables, 1 set and 1 form. There is an enclosed screen dump in JPEG format within the ZIP archive. This demonstrates the error message that is obtained whenever a record is updated via the form "Comp event round results".
To demonstrate the problem, extract the enclosed TESTIT Zip archive to any convenient folder and then open the "WGA competitions" database. Open the form "Comp event round results" and then try to update any of the fields in the imbedded browse at the bottom of the form. You will get the error "Record locked by another session or user".
Please can someone with A5v5 expertise tell me what I have to do to solve this problem.
The problem I have is I get an error whenever I try to update a record in table. The error is "Record locked by another session or user".
I have tried everything possible to get rid of this problem including packing the database and re-indexing all tables. I have tried re-booting, facing Mecca and even holding my breath in a wind change. Nothing works.
I originally thought the problem had been caused by my PC locking up (Windows XP). But this is not the case as several earlier backups of my database display exactly the same problem.
The problem is easily reproduced in the attached TESTIT database. It's compressed in Zip format.
I have pruned my TESTIT database down to the essentials needed to demonstrate the problem: 5 tables, 1 set and 1 form. There is an enclosed screen dump in JPEG format within the ZIP archive. This demonstrates the error message that is obtained whenever a record is updated via the form "Comp event round results".
To demonstrate the problem, extract the enclosed TESTIT Zip archive to any convenient folder and then open the "WGA competitions" database. Open the form "Comp event round results" and then try to update any of the fields in the imbedded browse at the bottom of the form. You will get the error "Record locked by another session or user".
Please can someone with A5v5 expertise tell me what I have to do to solve this problem.
Comment