[dba-SQLServer] Field missing in Linked SQL Table/View

Paul Hartland paul.hartland at googlemail.com
Wed Jan 13 13:31:55 CST 2016


Just off hand it sounds like a permissions thing, do you use the same logon
to run the view in SQL server as you are using for the linked tables to
Access ?

On 13 January 2016 at 18:40, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>
>
>
> I have an SQL 2012 database that belongs to another application which I
> have
> little control over.  I am allowed to create views of the tables.  I have
> created a view of a particular table which just selects a few of the fields
> from the table.  I have then linked the view to my Access 2010 database.
>
>
>
> The unusual thing is that one of the fields does not appear in the linked
> table in Access.  It is definitely in the view and appears when I run the
> view.
>
>
>
> I have tried linking directly to the SQL table and this includes all the
> fields except for the same field missing from the view.
>
>
>
> I have changed the view and relinked it - all of the changes show in the
> linked table except the same field doesn't show.
>
>
>
> There is nothing unusual I can see about the field.  It is a nvarchar(25).
> The type is a user defined data type but so are a number of other fields
> that all appear in the linked table.
>
>
>
> Has anyone come across this before?
>
>
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the dba-SQLServer mailing list