Very slow time to refresh data in linked DNS table

[jaryszek]

Hi,



i am inpputting into linked table using VBA now() function Time of input.
Problem is that my linked table is not refreshing ! while i am opening this,
in database (Dbeaver on Postgres):



In Access (times are not refreshed):




Why?

DNS is wrong or what?
I didnt have that kind of issue in other tables...

Best,
Jacek

[Gicu]

Jacek,

Have you considered moving the auditing to the back-end (here is an example using triggers: https://wiki.postgresql.org/wiki/Audit_trigger)? How do you use Now()? VBA, pass-through, linked table editing?

Cheers,
Vlad

[jaryszek]

Hi Vlad,

oo i should move table auditing and triggers to back-end but i solved the problem.
Problem was lack of primary key within table.

I am shocked that this cause the issue.

Best,
Jacek

[Minty]

You shouldn't be shocked - without a primary key it's very hard for the odbc link to keep track of what's being updated, with a MS SQL Server linked table 90% of update query's won't work without a primary key.

[jaryszek]

thank you Minty,

i had to see these on my own eyes ;-)