Fordraiders
asked on
linked sql server tables repeating time entries in access views
Access 2010
Linked sql server tables
Let me start by saying this question has nothing to do with duplicate data.
DATETIME fields repeating data for entries.
I have something strange that started recently.
When I view the Linked tables in Access.
It displays the data : as shown below...for a repeated ID
in sql server this is correct...( second entry)
not so concerned about the military time..but...the entries in Access are repeating...
if i had 5 entries..
they would all be the same ?
or maybe military time is causing the problem ?
Thanks
fordraiders
Linked sql server tables
Let me start by saying this question has nothing to do with duplicate data.
DATETIME fields repeating data for entries.
I have something strange that started recently.
When I view the Linked tables in Access.
It displays the data : as shown below...for a repeated ID
in sql server this is correct...( second entry)
not so concerned about the military time..but...the entries in Access are repeating...
if i had 5 entries..
they would all be the same ?
or maybe military time is causing the problem ?
Thanks
fordraiders
How about refreshing the records...what if you retrieve the records using a passthrough query ?
Not enough information, need to see the query that gathers the blue-lines with duplicate-dates.
My first guess would be that the two lines in blue are using the same date-field twice, and the correct SQL server result-set is using two different date-fields.
My first guess would be that the two lines in blue are using the same date-field twice, and the correct SQL server result-set is using two different date-fields.
ASKER
I needed a primary key in my table . I created a unique key field and worked fine.
Primary Keys and the timestamp fields are considered prerequisite when we do Access to SQL linkage...
Are you using a query with an Order By clause in BOTH situations? Tables are unordered sets of data and Access may be seeing different records than you see when you open the table in DS view. The only way to be absolutely certain is to use the exact same query AND Sort Order from Access and from SSMS.
ASKER
Pat, thanks i double checked...
primary key issue
primary key issue
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
You're welcome
The "military" style - the ISO format - is just the default display form of SQL Server, while Access uses the local settings from Windows.