Results 1 to 4 of 4
  1. #1
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065

    Linked table missing fields

    I have a table in SQL Server that includes a number of fields. 2 of those fields are used to link to other tables. I'm using a Microsoft Access 2010 Front End. Everytime I link to SQL Server those 2 fields are not displayed so I can't do any linking in Queries on the front end. Why would they disappear like that? Also I do not currently have sa privileges in SQL Server. The odd thing is if I'm in SQL Server Management Studio I can see the fields and query off of them Why would they disappear when linking through ODBC?

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936

  3. #3
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi, it's already some time ago I worked with access as a front end, but I seem to remember that when linking tables there is an option somewhere to hide the primary key fields.

  4. #4
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    Ok, after a lot of work and research I've determined the cause of the problem. The SQL Server Database we're using is a Commercial Database. If I login using Windows Authentication even with SA Rights there is Security in the Commercial Database that unless I sign in with the Same username and password that I use for the front end application I don't have access to all of the fields in the tables. If I login using the same username and password I use in the front end application they're available. Same goes with a number of views. using window Authentication those views have no data. Otherwise they're fine.

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

Similar Threads

  1. Linked Table Wizard Missing
    By sberti in forum Import/Export Data
    Replies: 1
    Last Post: 04-07-2016, 04:39 AM
  2. Replies: 4
    Last Post: 03-02-2015, 07:54 PM
  3. Missing fields in linked table
    By kdbailey in forum Access
    Replies: 2
    Last Post: 02-15-2014, 06:14 PM
  4. Missing data from linked table
    By tprice5 in forum Access
    Replies: 1
    Last Post: 06-28-2012, 02:35 AM
  5. Linked table from outlook missing columns
    By nehamd4 in forum Access
    Replies: 0
    Last Post: 07-21-2010, 12:58 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