|
Home > Archive > MS Access Multiuser > January 2006 > Refresh probelm with MS Access.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Refresh probelm with MS Access.
|
|
| swapna_munukoti@yahoo.co.in 2006-01-05, 3:24 am |
| Hi All,
I am using MS Access in our application. We are now updating our
application for multi-user environment. While testing I found that the
changes done in one client is not reflecting in the other client
immediately.
Even when I do some changes manually in DB, and try to see
immediately through application, it is taking time to show the changes.
Is this behaviour dependent on the "refresh interval" setting of the
DB? All the settings in DB are default settings. What shall I need to
do so that the client can see the changes immediately?
We are using ADO in our application.
Thanks,
Swapna.
| |
| Alex Dybenko 2006-01-05, 7:24 am |
| Hi,
you can play with tools-options-advanced-refresh interval settings.
or use form's timer event and requery form at specified interval
--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
< swapna_munukoti@yaho
o.co.in> wrote in message
news:1136452187.700839.211760@z14g2000cwz.googlegroups.com...
> Hi All,
>
> I am using MS Access in our application. We are now updating our
> application for multi-user environment. While testing I found that the
> changes done in one client is not reflecting in the other client
> immediately.
> Even when I do some changes manually in DB, and try to see
> immediately through application, it is taking time to show the changes.
> Is this behaviour dependent on the "refresh interval" setting of the
> DB? All the settings in DB are default settings. What shall I need to
> do so that the client can see the changes immediately?
> We are using ADO in our application.
>
> Thanks,
> Swapna.
>
| |
| swapna_munukoti@yahoo.co.in 2006-01-05, 9:24 am |
| Sorry, I did not mention earlier that my front-end is VB.
I did not under the logic of using form's timer event.
I don't know if the explanation of my problem is sufficient for u. Let
me explain u detail. In multi-user environment, one user has changed
the details of say an employee. And the second user even after
refreshing the screen, is not able to see those details immediately. If
the 2nd user refreshes his screen after 1 or 2 seconds, he is able to
see the updated details.
What I want to know is, is there a way so that the 2nd user can see
the details if he refreshes the screen immediately.
Thanks,
Swapna.
| |
| Alex Dybenko 2006-01-06, 7:25 am |
| Hi,
in this case you better ask in VB- related newsgroups
--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
< swapna_munukoti@yaho
o.co.in> wrote in message
news:1136468824.913825.18930@g14g2000cwa.googlegroups.com...
> Sorry, I did not mention earlier that my front-end is VB.
> I did not under the logic of using form's timer event.
> I don't know if the explanation of my problem is sufficient for u. Let
> me explain u detail. In multi-user environment, one user has changed
> the details of say an employee. And the second user even after
> refreshing the screen, is not able to see those details immediately. If
> the 2nd user refreshes his screen after 1 or 2 seconds, he is able to
> see the updated details.
> What I want to know is, is there a way so that the 2nd user can see
> the details if he refreshes the screen immediately.
>
> Thanks,
> Swapna.
>
|
|
|
|
|