[AccessD] Access 97 nasty behaviour of subform

no, FE and BE and Excel file are on same directory even

Lembit

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Sunday, October 01, 2006 11:52 AM
Subject: Re: [AccessD] Access 97 nasty behaviour of subform


> 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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com