Linked table has blank data (SQL Server data is visible) in Access it is not

[Pack10]

I am linking to a SQL Server 2008 R2 Express table. The table has data but in access the DOC_ID field (Key field) shows data but the other field is blank. I know it has data.

 

[dhookom]

Did you try to create a pass-through query to the table? What were the results?
What is the data type of "the other field"?

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

I figured this out. The unique ID field was messed up. I did it wrong. Now it brings in everything.