Error 109 - Record in use by another

[webpager]

I am running an application on a network of two machines.
I frequently get error 109 "Record in use by another", on one of the machines. This error occurrs even if the main program is only running on one machine. I am using auto locking. Is it possible that records are not being released for some reason, so when an attempt is made to edit the same record again, it is still locked from the previous edit. I have tried UNLOCK ALL in my error handler but the error still remains.
Can anyone suggest possible causes?

 

[ChrisCarroll]

This isn't an answer, but I'm having a similar problem.
Mine may - or may not - be connected with some combination of of table buffering (even on a table, opened exclusively, on a local drive) and using child forms to append rows to the table and then to edit them.

 

[ramani]

Generaly, when the same user locks the same record in a single scession, this error shall not happen. It is puzzling a little.

It is very likely, you are not triggering the UNLOCK button after the lock is placed. Just check in your code between the lines.. LOCK ... UNLOCK...
if there is any exit route. If present, do the UNLOCK and exit the routine. YOu shall be fine.

IF this does not help, please specify.. Is the routine used in a Form or in programme code?
Hope this is helpful ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[ramani]

Hi Chris and Webpager,

opening EXCLUSIVE is not a solution..

Have you SET REPROCESS TO AUTOMATIC

You can do in the place where you set autolock ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com