[AccessD] MDB Refresh interval

Charlotte Foust cfoust at infostatsystems.com
Wed Jul 2 11:36:38 CDT 2008


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




More information about the AccessD mailing list