Stuart McLachlan
stuart at lexacorp.com.pg
Sun Oct 1 04:52:37 CDT 2006
On 1 Oct 2006 at 11:01, Lembit Soobik wrote: > thank you, Stuart, > seems you are right. must be the Excel table not closing or such. > and I think it is not editing the subform. > Sometimes a long time delay between closing and opening the mainform agin > helps, Now I just found that in case of the error closing and then opening > the form fixes it. Is this running over a network? If so, it sounds like an "oplocks" problem. Try disabling Oportunistic Locking on the server. See http://support.microsoft.com/?kbid=296264 -- Stuart