Field Value not refreshed

[Cris]

I have a program where I am calling an application programmed in C#. When my process finish, it writes a value on a table on my Access database which a want to read. I am using a recordset to get this value on my code VBA. But the problem is that sometimes I am not getting the value updated if I don't wait for a few seconds (not always the same time).

I was looking on internet but the only thing i found was that Access has an interval of refreshing when the values are modified by other user and this applies to the forms for example. But I am not working with a form, in this case I am just reading the value with my recordset.

I would like to know if there is a way to force the database to refresh before reading my value.

Thanks in advance for your replies

 

[WayneRyan]

Cris,

If your process is inserting a value in some table, it probably is "instantaneous".

I'd think that you just have to work on requerying your recordset. The data should be
in your table without any noticable latency.

Wayne

 

[Cris]

Thanks Wayne for your reply.

In fact, I have already tried to requery the recordset but i didn't work. Anyway, I open the recordset after my c# application writes the new value on the table, so I suppose the new value should be there. I think this delay is similar to the situation when you have the table open and someone else modify the value and you can see it immediatly if you click on refresh button. I was wondering if there was something in vba to do the same.

Again thanks for all your replies