starrcruise
Registered User.
- Local time
- Yesterday, 23:59
- Joined
- Mar 4, 2011
- Messages
- 18
Good morning.
Was not sure where to post this. I have an issue that just began occurring. views, tables and queries have been working fine and now are not. Here are FAQs:
1. created sql server 2012 table and linked to access 2007-2010 db - call it dbo.224Ongoing
2. created sql server 2012 view and linked to access 2007-2010db - call it dbo.v224Ongoing.
3. have appendquery in access that pulls from dbo.v224Ongoing - data filtered on [created], a datetime field.
4. append is simple , no grouping, no aggregating. Data is underwriting conditions placed against loans within the correct [create] range. So a loan can have 1 to multiple conditions. Append should simply pull all conditions within filter. [create] filtered for one month.
5. Problem, in opening dbo.v224ongoing, dbo.224ongoing, and output of append, in access, data is showing duplicated. Rather than pulling each unique condition per loan, the above ALL show the latest condition information. So if a loan has five conditions, the above will list 5 rows, but all with the latest data showing rather than unique data.
6. the same query pulled in sql server against dbo.224going or dbo.v224ongoing shows the correct unique data.
Both dbo.224ongoing and dbo.v224ongoing have datetime datatype, and the dbo properties within access show them as being datetime datatype.
I have attached a word file that shows the output from access and sql server and the property tables. This problem just started and both myself and db administrator have tried to figure out the problem with no luck. Hope someone can help. Please let me know what other information is needed.
Thank you.
Was not sure where to post this. I have an issue that just began occurring. views, tables and queries have been working fine and now are not. Here are FAQs:
1. created sql server 2012 table and linked to access 2007-2010 db - call it dbo.224Ongoing
2. created sql server 2012 view and linked to access 2007-2010db - call it dbo.v224Ongoing.
3. have appendquery in access that pulls from dbo.v224Ongoing - data filtered on [created], a datetime field.
4. append is simple , no grouping, no aggregating. Data is underwriting conditions placed against loans within the correct [create] range. So a loan can have 1 to multiple conditions. Append should simply pull all conditions within filter. [create] filtered for one month.
5. Problem, in opening dbo.v224ongoing, dbo.224ongoing, and output of append, in access, data is showing duplicated. Rather than pulling each unique condition per loan, the above ALL show the latest condition information. So if a loan has five conditions, the above will list 5 rows, but all with the latest data showing rather than unique data.
6. the same query pulled in sql server against dbo.224going or dbo.v224ongoing shows the correct unique data.
Both dbo.224ongoing and dbo.v224ongoing have datetime datatype, and the dbo properties within access show them as being datetime datatype.
I have attached a word file that shows the output from access and sql server and the property tables. This problem just started and both myself and db administrator have tried to figure out the problem with no luck. Hope someone can help. Please let me know what other information is needed.
Thank you.