lag in access to read sql server tables

Fordraiders
Fordraiders used Ask the Experts™
on
access linked tables to sql server  lag time  ?

I have a table i'm collecting dates/time

When i bring up the table I have an id field  and 2 other fields.

The times at certain points are repeated dates, so it looks like it not recording properly.
When i go into sql server they data looks fine.

from access
from sql server :
from sql server

Trying to figure what would cause the lag ?


Thanks
fordraiders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Is the column on the right a computed (aka calculated) column?  It is not possible for data to change solely based on what is accessing it.

>The times at certain points are repeated dates, so it looks like it not recording properly.
Unless you show us the code that generates this data, and define 'proper',  there's no way experts here can speak to if it is 'proper' or not.
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
What is "go into SQL Server" and what is "from SQL Server"?

You first picture looks like viewed in Access, the last like viewed in SSMS.

Author

Commented:
linked to sql server.
You first picture looks like viewed in Access, the last like viewed in SSMS. =  yes
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Seems like the same record is read twice. Perhaps you should add a SQL Server timestamp field to the table and relink.

Author

Commented:
thanks guys

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial