Someone Locked this record
Someone Locked this record
(OP)
We are working in network to build a database, but every day, at least five times in a day, the system is getting blocked without using find functions.
The error message is "Someone locked this record".
Could you give me any advices?
The error message is "Someone locked this record".
Could you give me any advices?
RE: Someone Locked this record
Occasionally, a problem with an index file may generate bogus locking errors. You can often clear them by:
1. Get everybody out of Approach
2. Take a backup
3. Open each dbf in turn directly in Approach
4. From the new apr, compress the dbf: File | User Setup | Approach Preferences | Database tab
5. Discard the apr without saving
Afterwards, check there are no .OYZ files present which indicate serious index problems.
Compressing a dbf physically removes records marked as deleted and rebuilds minimal index files. When you next open the apr, you may have to wait a few seconds while further SmartIndexes are built.
BTW, I have authored and published a component, DBFPack, to automate the compression process for multiple dbf files. An evaluation copy can be downloaded from my web site.
Paul Bent
Northwind IT Systems
http://www.northwindit.co.uk