I dont understand why, after a committrans, i dont see in the access ide the new value added in table buf only after a few seconds. Peraphs i need to force via code the update?
Symilar with requery or a refresh ecc....
Note::
My access database is located on a Lan dir
force refresh to the value in table
-
sal21
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
-
HansV
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: force refresh to the value in table
Does this happen if you have the table open in Access during the transaction, or do you open the table after running the transaction?
Best wishes,
Hans
Hans
-
sal21
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
Re: force refresh to the value in table
After running transaction....HansV wrote:Does this happen if you have the table open in Access during the transaction, or do you open the table after running the transaction?
-
HansV
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: force refresh to the value in table
I don't think you can do anything about that...
Best wishes,
Hans
Hans
-
sal21
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
Re: force refresh to the value in table
Wath you think about:HansV wrote:I don't think you can do anything about that...
Dim Jet As Object
On Error Resume Next
Set Jet = CreateObject("JRO.JetEngine")
If Not Jet Is Nothing Then
Jet.RefreshCache CN
End If
-
HansV
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: force refresh to the value in table
You'd have to experiment. I have no idea whether that will help or not.
Best wishes,
Hans
Hans