Results 1 to 2 of 2
  1. #1
    wil is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    7

    Linked table from SQL doesn't contain entire table

    I have a SQL 2005 table that is linked to an Access 2007 table. the SQL table has 179 records, but the Access table only has 49.



    Why would Access limit the fields it pulls across in a linked table?

    Any help or advice would be appreciated!

  2. #2
    wil is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    7

    data source issue

    the linked table used a data source from a separate DB in SQL.

    here's a good example of why it's important to clearly identify your testing environment as such in all related areas. The view-only user I created in SQL to define the data source in Access had the same name and since it wasn't labeled "testing viewer" (or something) I never recreated when I moved into Production.

    I fail at cool.

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

Similar Threads

  1. How to loop code to run through entire table
    By kmajors in forum Reports
    Replies: 9
    Last Post: 04-23-2010, 09:27 AM
  2. Replies: 3
    Last Post: 01-21-2010, 08:10 PM
  3. Linked Table To SQL Server?
    By snkscore in forum Import/Export Data
    Replies: 3
    Last Post: 12-09-2009, 06:36 AM
  4. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  5. Query on a linked table?
    By SilverSN95 in forum Queries
    Replies: 1
    Last Post: 09-26-2009, 03:00 PM

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 - Senior Forums