[AccessD] Access 97 nasty behaviour of subform

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





More information about the AccessD mailing list