[AccessD] MDB Refresh interval

Thanks Charlotte
My question has been answered.

Charlotte Foust wrote:

>I see.  Yes, the refresh interval should make all the difference if
>you're going to use bound forms that way.
>
>Charlotte Foust 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
>Sent: Wednesday, July 02, 2008 5:34 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] MDB Refresh interval
>
>Hey Charlotte
>I have a little network setup in my office, 3 machines linked to a
>server.  I have put the data on the server. Then on two of  the
>machines, I start up the program and  open the same data entry
>continuous form.
>
>On one machine the form is an edit/update form, on the other it is a
>view only form.
>The idea being that when a record is deleted or changed I set a flag,
>the OnTimer event for the view machine checks for this flag, if it finds
>it, it refreshes/requeries the view form.
>
>I was running a .1% scenario, "What if one user was viewing the data
>while another user deleted a bunch of records one right after the other
>real quickly", what would happen to the display on the view machine.
>
>Somtimes, not always  I could trip up the program and cause error
>messages to be displayed. 
>
>By reducing the refresh interval this problem seems to have gone away. I
>was just wondering if  this was truly a solution to the problem.
>
>Charlotte Foust wrote:
>
>  
>
>>I don't think I understand what you mean by "on another machine"?  Are 
>>you using remote access to a machine or are you deleting the records 
>>    
>>
>>from the form in an instance running on your desktop?
>  
>
>>Charlotte Foust
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
>>Sent: Wednesday, July 02, 2008 4:37 AM
>>To: Access Developers discussion and problem solving
>>Subject: [AccessD] MDB Refresh interval
>>
>>Hey All
>>I have been doing some testing on a program, deleting a group of 
>>records when muiltiple users are online working in the same bound form.
>>I was getting at times error messages, on one machine when I deleted a 
>>group of  records on  another machine. In fact  the one machine would 
>>lose the record source at times.
>>Now a question for the network experts, I dropped the refresh rate from
>>    
>>
>
>  
>
>>60 down to 20 seconds, and the problem seems to have gone away.  Is 
>>this coincidence or would doing this really eleviate the problem.
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>> 
>>
>>    
>>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>