Results 1 to 3 of 3
  1. #1
    RayMilhon is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,066

    Linked Table Question

    I have an Access 2010 Database that links to a SQL Server View. If I look at the view in SQL Server with specific criteria I get 54 Records. If I run the exact same query in Access for the attached view I also get 54 records however some of the records are duplicated where they are not in SQL Server. I've narrowed it down that we have a product line field and a sub-measure field. If the sub-measure field is the same but the product line field is different I get 2 records for the same product line and the other product line is missing. Anybody have an idea why this would happen?

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    Do you have any of the "Lookup" tabs configured for any off the fields in the MSAccess table in design view. These are the biggest deceiver of data.

  3. #3
    RayMilhon is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,066
    No I don't. I don't use Lookups in MS Access at all. Never have. I did try and import the view rather than link to it and the data was correct. It's only in the view that the data is incorrect.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Question on database structure - limiting linked records
    By andrewb in forum Database Design
    Replies: 2
    Last Post: 03-22-2012, 05:41 PM
  2. Replies: 3
    Last Post: 12-06-2011, 11:32 AM
  3. Replies: 0
    Last Post: 11-30-2010, 12:23 PM
  4. Replies: 3
    Last Post: 01-21-2010, 08:10 PM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums